If we required comma separated values form one to column in multiple rows.
Thank you for reading this post, don't forget to subscribe!Example
CREATE TABLE EMP
(
EID INT IDENTITY,
ENAME VARCHAR(100),
DEPT VARCHAR(100)
)
INSERT INTO EMP(ENAME,DEPT)
VALUES(‘ABC’,’SALE’),
(‘PQR’,’IT’),
(‘XYZ’,’HR’),
(‘MNL’,’ADMIN’)
DECLARE @DEPT VARCHAR(255)
SELECT @DEPT=COALESCE(@DEPT + ‘, ‘, ”) + CAST(DEPT AS VARCHAR(100))
FROM EMP
SELECT @DEPT as ‘Department’
Output
Department
—————–
SALE, IT, HR, ADMIN