bull2000
SSC Eights!
Points: 841
More actions
March 20, 2005 at 6:35 pm
#61666
the data looks like this:
PartNo Location
P1 Loc1
P1 Loc2
P1 Loc3
P2 Loc2
P2 Loc4
I need to list all the locations for each part:
P1 Loc1,Loc2,Loc3
P2 Loc2,Loc4
Is there a way that can be done without using cursor and temp table?
thanks a lot.
Frank Kalis
SSC Guru
Points: 111183
March 21, 2005 at 2:14 am
#547956
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true
-- Frank Kalis Microsoft SQL Server MVP Webmaster: http://www.insidesql.org/blogs My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
March 21, 2005 at 6:48 am
#547989
Thanks a lot Frank.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply