Concatenate Field Values in one String using CTE in SQL Server

The new feature of CTE or Common Table Expression is used here to concatenate the values of a field in a single string.