sql server get Comma Separated Values in SQL

Question

i have one table CreativeID SiteID SectionIDs 706029 125443 128322 706044 125444 128323 706044 125444 128370 i need it CreativeID SiteID SectionIDs 706029 125443 128322 706044 125444 128323,128370 How is it possible

Shahriar Nikkhah · Answer

are you using SQL 2016 + ??? try this https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql?view=sql-server-2017

Manish Kumar · Answer

Try below query declare @tbl table (id int, siteid int, sectionid int ) insert into @tbl select 706029,125443,128322 union all select 706044,125444,128323 union all select 706044,125444,128370 select * from @tbl select id,siteid,substring ((select ','+cast(sectionid as varchar(100)) from @tbl a where a.siteid=b.siteid for xml path('') ),2,100 ) as sectionid from @tbl b group by id,siteid

Manav Pandya · Answer

Hello You can do this in many ways like : - COALESC - With CTE etc .. Follow few articles , which help you do get comma seperated values : https://www.aspsnippets.com/Articles/Select-Column-values-as-Comma-Separated-Delimited-string-in-SQL-Server-using-COALESCE.aspx https://stackoverflow.com/questions/21760969/multiple-rows-to-one-comma-separated-value https://www.codeproject.com/Tips/830404/How-to-Get-SQL-Column-Values-as-Comma-Separated-St https://www.c-sharpcorner.com/UploadFile/ee01e6/how-to-get-comma-separated-values-in-sql-server-with-group/ Thanks

Ravi Kiran Chanduri · Answer

To get comma separated values, STUFF is the best in MS SQL server . you will get solution in the following link https://stackoverflow.com/questions/31211506/how-stuff-and-for-xml-path-work-in-sql-server/31212041

CreativeID	SiteID	SectionIDs
706029	125443	128322
706044	125444	128323
706044	125444	128370