1- Create Table Emp
SET ANSI_NULLSON
GO
SET QUOTED_IDENTIFIERON
GO
CREATE TABLE [dbo].[Emp](
[Emp_Code] [int] NULL,
[Emp_Name] [nvarchar] (50)NULL)
ON [PRIMARY]
GO
2- Insert Data
Insert into Emp values (1,‘Mostafa’),(1,‘Moahmed’),(2,‘Elsayed’),(2,‘Elmasry’)
GO
3- Create comma-separated list
WITH CTE AS (
SELECT DISTINCTEmp_Code FROM Emp )
SELECT Emp_Code, CommaList =STUFF((SELECT‘,’+ Emp_name FROM Emp
WHERE Emp_Code = CTE.Emp_Code ORDERBY Emp_name
FORXMLPATH(”),TYPE).value(‘.’,‘varchar(max)’),1,1,”)FROM CTE
ORDERBY Emp_Code;
Like this:
Like Loading...
Related
Published by Mustafa EL-Masry
I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page
https://mostafaelmasry.com/about-me/
View all posts by Mustafa EL-Masry
DB Cloud TECH 