DECLARE @XYList AS varchar(MAX) -- Leave as NULL SELECT @XYList = COALESCE(@XYList + ',', '') + CONVERT(nvarchar(20), ID)+ ',' FROM emp
Select (Stuff((Select ', ' + FName From Accounts FOR XML PATH('')),1,2,''))
declare @s varchar(8000) set @s = '' select @s = @s + cloumnname + ',' from tablename where ... set @s = stuff(@s,len(@s),1,'')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)