SQL Server query using STUFF and FOR XML PATH to merge multiple skill values into one comma-separated string in result set.

This screenshot displays a query run in SQL Server Management Studio, showing how to use the STUFF function in combination with FOR XML PATH to concatenate multiple skill entries from a table into a single, comma-separated string. The result includes .NET, SQL, WebAPI, and PHP, all combined into one line. This technique is commonly used for flattening rows into a single cell in SQL queries.

×

Table Of Content