I am querying a database that is setup in a weird fashion. It has a work order field, a index field, and a text field. So below work order "9" says "DISPENSER 1 MIDGRADE PUMP NOT WORKING" and as you can see 9 has two sequence numbers. I need to find a way to combine these into 1 row that would have just the number 9 and the text. Anyone have any recommendations?
<tbody>
</tbody>
[FONT="]smwd_wo_quote_nbr[/FONT] | [FONT="]smwd_seq[/FONT] | [FONT="]smwd_text[/FONT] | [FONT="]smwd_flag[/FONT] |
[FONT="]1[/FONT] | [FONT="]1[/FONT] | [FONT="]breakaway off of pump #2[/FONT] | [FONT="]W[/FONT] |
[FONT="]3[/FONT] | [FONT="]1[/FONT] | [FONT="]Test for External Customer.[/FONT] | [FONT="]W[/FONT] |
[FONT="]9[/FONT] | [FONT="]1[/FONT] | [FONT="]DISPENSER 1 MIDGRADE PUMP NOT[/FONT] | [FONT="]W[/FONT] |
[FONT="]9[/FONT] | [FONT="]2[/FONT] | [FONT="]WORKING.[/FONT] | [FONT="]W[/FONT] |
[FONT="]10[/FONT] | [FONT="]1[/FONT] | [FONT="]Dispenser on midgrade not[/FONT] | [FONT="]W[/FONT] |
[FONT="]10[/FONT] | [FONT="]2[/FONT] | [FONT="]working.[/FONT] | [FONT="]W[/FONT] |
[FONT="]16[/FONT] | [FONT="]1[/FONT] | [FONT="]Dispenser 1 not pumping. Hose[/FONT] | [FONT="]W[/FONT] |
[FONT="]16[/FONT] | [FONT="]2[/FONT] | [FONT="]fell off.[/FONT] | [FONT="]W[/FONT] |
<tbody>
</tbody>
Last edited: