Making Rows of a Column in a Table into a Single Row in SQL Server
In this article, I will give information about converting the rows of a column in a table into a single row in SQL Server.
In SQL Server, in some cases, we may want to combine the rows of a column in a table into a single row.
You can easily do this using the code below.
--Method 1 DECLARE @Categories VARCHAR(8000); SELECT @Categories = COALESCE(@Categories + ', ', '') + ISNULL(CategoryName, 'N/A') FROM dbo.Categories; PRINT @Categories --Method 2 SELECT STUFF( ( SELECT N', ' + CategoryName FROM dbo.Categories FOR XML PATH(''), TYPE ).value('text()', 'nvarchar(max)'), 1, 2, N'' );
When you run the above code, you will get a result similar to the one below.
As you can see, we have combined the rows of a column in the table into a single row in SQL Server.
Good luck to everyone in business and life.