Return rows as 1 line?

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