robrodp
asked on
create single string from multiple records ms sql 2005
I have a table with records.They are grouped by an id.
say john 1
mike 1
terry 1
frank 2
jerry 2
misty 3
harry 3
molly 3
sam 3
I need to create a table (3 records inthis case)
john maike terry (record 1)
frank jerry (record 2)
misty harry molly sam (record 3)
What query can I use
say john 1
mike 1
terry 1
frank 2
jerry 2
misty 3
harry 3
molly 3
sam 3
I need to create a table (3 records inthis case)
john maike terry (record 1)
frank jerry (record 2)
misty harry molly sam (record 3)
What query can I use
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.