Databases
StackOverflow2013
Postsdbo
POSQL Concatenate View
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL Concatenate View
    primarykey
    data
    text
    <p>I need to create a view to concatanate a number of lines into a single line.</p> <p>The table in question is QotMaster, and I need to join all lines from the NComment field where LineType = '6' and im guessing to group them under each quote to group by the Quote field. Each of the lines to concatenate has the field Line and starts at 2 and increases depending on how many lines there are to the quotes comment.</p> <p>Ultimately i'd like a single line to read:</p> <pre><code>Quote NComment 00202300 Lines for quotes all listed one after the other starting at 2 and so on </code></pre> <p>Any help would be greatly apreciated. Ive tried to dump a section I need concatenating below. </p> <pre><code>Quote Line LineType DefaultEntry ProductClass TaxCode FedSalesTax MStockCode MDescription MWarehouse MUom MDecimals MLineShipDate MCusStockCode MCusRetailPrice MMass MVolume MUserField1 NComment NCommentFromLin NCommentType NCommentTextTyp NSrvIncTotal NSrvSummary NSrvChargeType NSrvParentLine NSrvQtyFactor NSrvApplyFactor NSrvDecimalRnd NSrvDecRndFlag NSrvMinValue NSrvMaxValue NSrvMulDiv NPrtOnInv NPrtOnDel NPrtOnAck NPrtOnQuote NCommentFlag1 NCommentFlag2 NCommentFlag3 NCommentFlag4 NCommentFlag5 NCommentFlag6 NCommentPoJob TimeStamp Version Release SalesOrderLine MBomFlag MParentKitType MQtyPer MScrapPercentage MPrintComponent MComponentSeq MOptionalFlag Estimate ConfirmedFlag 00202300 1 7 0 M20 002023000000001 Periodic inspection &amp; test ** 0 2012-01-13 00:00:00.000 0.00000 0.000000 0.000000 0 0 0.000000 0 0.00 0.00 0 0 0 0 0 0 0x000000002414E6EE 0 0.000000 0.00 N 00202300 2 6 0 0 NULL 0.00000 0.000000 0.000000 Pre-Formed Windings, Sheffield 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C0 0 0.000000 0.00 00202300 3 6 0 0 NULL 0.00000 0.000000 0.000000 To carry out a periodic inspection and test 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C1 0 0.000000 0.00 00202300 4 6 0 0 NULL 0.00000 0.000000 0.000000 of the fixed wiring installation. This will 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C2 0 0.000000 0.00 00202300 5 6 0 0 NULL 0.00000 0.000000 0.000000 consist of 100% inspection and 10% testing, 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C3 0 0.000000 0.00 00202300 6 6 0 0 NULL 0.00000 0.000000 0.000000 based on previous records being available. 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C4 0 0.000000 0.00 00202300 7 6 0 0 NULL 0.00000 0.000000 0.000000 The price is based on no serious defects 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C5 0 0.000000 0.00 00202300 8 6 0 0 NULL 0.00000 0.000000 0.000000 being found, which may result in the testing 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C6 0 0.000000 0.00 00202300 9 6 0 0 NULL 0.00000 0.000000 0.000000 being expanded to cover 25%, which would 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C7 0 0.000000 0.00 00202300 10 6 0 0 NULL 0.00000 0.000000 0.000000 incur additional costs. A full report will 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C8 0 0.000000 0.00 00202300 11 6 0 0 NULL 0.00000 0.000000 0.000000 be issued upon completion. 0 N 0 0.000000 0 0.00 0.00 Y 1 0 0 0 0 0 0x000000002414E6C9 0 0.000000 0.00 </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOcaso Protal
    1. USlewiscooksey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COso, what have you tried that does not work? Or are you expecting some one here to do it for you?
      singulars
      1. POSQL Concatenate View
      1. USItay Moav -Malimovka
    2. COWhich RDBMS do you use?
      singulars
      1. POSQL Concatenate View
      1. USOcaso Protal
    3. CO@ItayMoav Im not exactly a SQL expert as you can see, i was just after some advice on how to do it, on looking at how to concatenate lines i drew a blank.
      singulars
      1. POSQL Concatenate View
      1. USlewiscooksey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload