Rows to Column transpose

SELECT [id]

      ,[nam]

      ,[city]

  FROM [aaaa]

GO

DECLARE @str VARCHAR(100)

SELECT @str = COALESCE(@str + ' ,', '') + [city]+[nam]  FROM [aaaa]

SELECT category= @str

 
 

-- contributed by Sheju Gangadharan