Saturday 18 November 2017

Using STUFF get multiple column Names in sing string in sql server


//// Sql

DECLARE @cols AS NVARCHAR(MAX),@Flg varchar(10)='18'
select @cols = STUFF((SELECT distinct ',[' + Description + ']' FROM mstLookup where lookupflag=@Flg FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')

print @cols


//// Result



No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...