select order and comma delimited list

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » select order and comma delimited list

select order and comma delimited list

Rate Topic

Display Mode

Topic Options

Author

Message

kevin 20860

Posted Thursday, February 14, 2013 4:25 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:55 AM
Points: 10, Visits: 28

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.

mytable
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?
thanks

Post #1419967

Sean Lange

Posted Thursday, February 14, 2013 7:58 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:48 PM
Points: 8,601, Visits: 8,242

The original thread is here. http://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ 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

Post #1420087

« Prev Topic | Next Topic »

Permissions