Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
Declare @Var1 nvarchar(800)
Set @Var1=’’
Select @Var1 = @Var1 + ‘,’ + Field1 from Table1
Select @Var1