Return rows as 1 line?
Date: Mon, 17 May 2010 13:17:09 -0700 (PDT)
Ok, I am hoping this is now going to be nuts, but say I have data like this:
ID PRODUCT SKU 1 ABC 123 1 DEF 456 2 XYZ 000 2 MNO 999 3 GHI 888
And this is what I would need:
1,ABC:123,DEF:456 2,XYZ:000,MNO:999 3,GHI:888
So, records that have a certain criteria would have certain columns concatenated. I'm thinking of putting together a dynamic query and then opening a cursor and selecting from it, creating the string as I go along.
Any thoughts? I'm going to go with the dynamic cursor unless someone else has a better idea. Received on Mon May 17 2010 - 15:17:09 CDT