StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIF loops within Select Statements SQL Server 2008?
text
Body
copied!<p>Let's say I have a table called <code>Details</code> with 4 columns:<code>OrderNo</code>, <code>Name</code>, <code>Qty</code>, and <code>Weight</code>. I am iterating through the table and selecting the needed fields, concatenating a string out of the data. For example:</p> <pre><code>----------------------------------------------------------------- | OrderNo | Name | Qty | Weight | ----------------------------------------------------------------- | a1234 | HDMI_Cable | 2 | 0.1 | | a1234 | Aux_Cable | 1 | 0.1 | | b5346 | 2.1_Speakers | 1 | 3.5 | | t5485 | 3.5mm_Adapter | 5 | 0.1 | ----------------------------------------------------------------- </code></pre> <p>So with this data, what I would do is iterate through the table and concatenate the data separated by a semicolon (;), then each row separated by a '>'. For the second and third row, this would give me:</p> <p><code>a1234;Aux_Cable;1;0.1>b5346;2.1_Speakers;1;3.5></code></p> <p>The complicated part is that when the order number is the same, I'd like to append it to the previous row without repeating the order number. For example, row 1 and 2 would look like:</p> <p><code>a1234;HDMI_Cable;2;0.1;Aux_Cable;1;0.1></code></p> <p>I have tried using IF loops and cases with nested select statements, but I keep running into endless errors and can never seem to get it to work. Anyone have any idea on how to do this or if it can be done? Thanks for reading!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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