Merge multiple rows with comma separated value in SQL Server

Question

I have a list of diseases and balanceshow can i use sql server to display thisNameBalanceDescriptionmusoke20000Malaratyphoidmusoke50000MalaratyphoidCovid 19thanks

dharmendr · Accepted Answer

Use STUFF function to merge the column from multiple rowsReferMerge Combine multiple rows value with comma separated in single row using STUFF function in SQL Server Merge multiple rows based on id and display in one row using SQL Server

Merge multiple rows with comma separated value in SQL Server

Company

Explore

Follow us

Contact Us

Name	Balance	Description
musoke	20000	Malara,typhoid
musoke	50000	Malara,typhoid,Covid 19