InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:36:51 GMT20http://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspxThanks for that. Worked perfectly.Thu, 14 Feb 2013 07:09:59 GMTkevin 20860http://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspxSample data: -[code="sql"]IF object_id('tempdb..#testEnvironment') IS NOT NULLBEGIN DROP TABLE #testEnvironment;END;SELECT ID, NameINTO #testEnvironmentFROM (VALUES(1, 'Fred'),(2, 'Joe'),(3, 'Bob'))a(ID, Name);[/code]Query: -[code="sql"]DECLARE @Delimitedlist VARCHAR(8000) = '1,3,2';SELECT STUFF((SELECT ','+a.Name FROM #testEnvironment a INNER JOIN (SELECT ItemNumber AS Ordering, Item FROM dbo.DelimitedSplit8K(@Delimitedlist,',') ) b ON a.ID = b.Item ORDER BY b.Ordering FOR XML PATH(''), TYPE).value('.','NVARCHAR(MAX)'),1,1,'');[/code]Result: -[code="plain"]Fred,Bob,Joe[/code]dbo.DelimitedSplit8K function can be [url=http://www.sqlservercentral.com/articles/Tally+Table/72993/]found here --> http://www.sqlservercentral.com/articles/Tally+Table/72993/[/url].Solution will only work if your original deliminated string is never more than 8000 characters.Thu, 14 Feb 2013 04:58:44 GMTCadavrehttp://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspxSorry. The other one is in the wrong forum. I went back to delete it but there is no "delete" option. Should be in this forum only.thanks,Thu, 14 Feb 2013 04:31:10 GMTkevin 20860http://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspxtut tut tut.... don't cross-post Kevin! ;-)[url]http://www.sqlservercentral.com/Forums/Topic1419967-8-1.aspx[/url]Thu, 14 Feb 2013 04:29:14 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1419969-392-1.aspxHi all,Have an issue with a comma delimited list which is giving me a headache. Any suggestions would be appreciated.Delimited list 1,3,2I need to take each item from the list and match it to another table of names which in turn will be comma delimited. mytableID Name1 Fred2 Joe3 BobThe result I'm looking for is: Fred,Bob, JoeWhat'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.For clarity if you break down my code to: select name from mytable where id in (select id FROM dbo.ufn_split(path)) it will give you a different order to this:select id FROM dbo.ufn_split(path)Any ideas?thanksThu, 14 Feb 2013 04:28:10 GMTkevin 20860