How to create the row data as string.
If you have table row data and you need to show all the records in a single string, use the following query.
DATA: --------------------Name RAM SHYAM HARI RITA
RESULT: ---------------------Name RAM,SHYAM,HARI,RITA
Use the following query ------------------------------------DECLARE @strList varchar(100) SELECT @strList = COALESCE(@strList + ', ', '') + CAST(Name AS varchar(5)) FROM TABLE1 SELECT @strList
There are complex example in internet but you can use this simple query to get this solutions. No need to use complex cursor to get such result.
Filed under: Table Row in String | Tagged: COALESCE, How to create a row data as string., MSSQL tisp, MSSQL tricks, Multiple value in single String, SQL help, String creation | 1 Comment »