InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:39:19 GMT20http://www.sqlservercentral.com/Forums/Topic1381927-392-1.aspxIf you want to generate a list of values from a column of values, like this, your best bet is to use For XML Path to do the work for you.Bing/Google/whatever "concatenate string sql server for xml" or "sql server for xml path", and you'll find articles and tutorials on how to do this. It's very fast, effective, and quite a neat trick.Wed, 07 Nov 2012 06:27:36 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1381927-392-1.aspxok......Got it thanks....:-)Wed, 07 Nov 2012 06:05:34 GMTSaurvhttp://www.sqlservercentral.com/Forums/Topic1381927-392-1.aspxIt's not a bug. The syntax you are using is never reliable to get string concatenation in T-SQL. BTW, Order By 1 in your first sample, is not inequivalent to Order By seq... It is equal to [code="sql"]order by @comma_Delimited + k + ',' [/code] Wed, 07 Nov 2012 06:02:07 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1381927-392-1.aspxwhy is the difference between both outputs ...--SQL1: Declare @tab table (seq int , k varchar(20))declare @comma_Delimited varchar(max)set @comma_delimited=''insert into @tabselect 1,'s'union allselect 2,'K'union allselect 3,'t'union allselect 4,'l'select @comma_Delimited =@comma_Delimited + k + ',' from @tab order by 1select @comma_Delimited--SQL2.Declare @tab table (seq int , k varchar(20))declare @comma_Delimited varchar(max)set @comma_delimited=''insert into @tabselect 1,'s'union allselect 2,'K'union allselect 3,'t'union allselect 4,'l'select @comma_Delimited =@comma_Delimited + k + ',' from @tab order by seqselect @comma_DelimitedWhy "Order by 1" is creating difference ...?Wed, 07 Nov 2012 05:51:41 GMTSaurv