Create table #abc(id int identity(1,1), val int default 2)
Insert into #abc default values
Go 1000000
Select stuff((select ','+cast(id as nvarchar(max))+cast('-' as nvarchar(max))+cast(val as nvarchar(max)) from #abc for xml path('')),1,1,'')
Output Value getting truncated
Please help me