Tuesday 1 December 2020

Order the result of a comma separated string generated with STUFF in sql server

 Sql query


DECLARE @Cols nvarchar(max);

SET @Cols = STUFF((SELECT ', ' + QUOTENAME(para_name) FROM t_WQ_Cont_list ORDER BY rpt_seq FOR XML PATH(''), TYPE).value('.', 'nvarchar(MAX)'),1,1,'')

SELECT @Cols;



///////// Result


 [Cl], [EC], [TDS], [Fe], [pH], [SO4]





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 ,","...