Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

combine multiple rows into one dynamically query question Expand / Collapse
Author
Message
Posted Wednesday, March 06, 2013 1:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:18 PM
Points: 22, Visits: 83
What code should I use in SQL 2000 then?
Post #1427608
Posted Wednesday, March 06, 2013 2:35 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:14 AM
Points: 421, Visits: 774
something along the lines of...
Declare @assignTo nvarchar(4000) 
select @assignTo = Coalesce(@assignTo + ', ', '') + CAST(Name as nvarchar(250))
from
table2
where
...
Select @assignTo

but fair warning that won't work in a subquery..to use it in a correlated subquery you'll have to write it into a UDF with table access.

Umm....as far as I know. It's been a while.
Post #1427639
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse