Wednesday 14 May 2014

Select all rows and particular data with Commas in Sql server

DECLARE @name NVARCHAR(MAX)
SELECT @name= COALESCE(@name + ',', '') + [Column Name] FROM [Table Name]
SELECT [Column Name] = @name

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