Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

select order and comma delimited list Expand / Collapse
Posted Thursday, February 14, 2013 4:25 AM


Group: General Forum Members
Last Login: Tuesday, January 21, 2014 6:39 AM
Points: 10, Visits: 34
Sorry ignore this -- Should be in the sql 2008 forum


Hi all,
Have an issue with a comma delimited list which is giving me a headache. Any suggestions would be appreciated.

Delimited list 1,3,2

I need to take each item from the list and match it to another table of names which in turn will be comma delimited.

ID Name
1 Fred
2 Joe
3 Bob

The result I'm looking for is: Fred,Bob, Joe

What's I've done is the following:
declare @path varchar(100)
select @path = '1,3,2'
stuff((select name from mytable where id in (select id FROM dbo.ufn_split(path) for xml path('')),1,1,'')

This works except that the "select ..where in " changes the order. Ie the names that are pulled from mytable are not in the same order as the id's in @path.

Any ideas?
Post #1419967
Posted Thursday, February 14, 2013 7:58 AM



Group: General Forum Members
Last Login: Tuesday, December 6, 2016 8:08 PM
Points: 16,145, Visits: 16,850
The original thread is here.


Need help? Help us help you.

Read the article at for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1420087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse