ivan_belal
asked on
String rows into column - help.
Hi, Experts:
I have a table as:
Ukey,Sequence,Data
1,1,note1
1,2,note2
1,3,note3
Sequence is not fixed, but random. Records are joined with Ukey.
I need to produce one row per Ukey as:
1,1,note1 [newline] note2 [newline] note3
Note: Sequence 1 is updated. How can I do this in Sql 2005.
Thanks,
I have a table as:
Ukey,Sequence,Data
1,1,note1
1,2,note2
1,3,note3
Sequence is not fixed, but random. Records are joined with Ukey.
I need to produce one row per Ukey as:
1,1,note1 [newline] note2 [newline] note3
Note: Sequence 1 is updated. How can I do this in Sql 2005.
Thanks,
ASKER
This is good; however I need to order by sequence so, data are placed sequencially.
Now I get note1 note3 then note2 for example.
Can you plz update your query ? Thx
Now I get note1 note3 then note2 for example.
Can you plz update your query ? Thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window