Hi
Refer below SQL Query Sample which full fill your requirement
SQL
DECLARE @Theatre AS TABLE(Name VARCHAR(50),[Time] VARCHAR(50))
INSERT INTO @Theatre (Name,[Time]) SELECT 'Gokul', '10:30'
INSERT INTO @Theatre (Name,[Time]) SELECT 'Gokul', '2:30'
INSERT INTO @Theatre (Name,[Time]) SELECT 'Gokul', '6:30'
INSERT INTO @Theatre (Name,[Time]) SELECT 'Gokul', '9:30'
INSERT INTO @Theatre (Name,[Time]) SELECT 'Satyam', '10:30'
INSERT INTO @Theatre (Name,[Time]) SELECT 'Satyam', '2:30'
INSERT INTO @Theatre (Name,[Time]) SELECT 'Satyam', '6:30'
SELECT t.Name as [Theatre Name]
,(SELECT ' ' + t1.[Time]
FROM @Theatre t1
WHERE t1.Name = t.Name
FOR XML PATH('')) [Time]
FROM @Theatre t
GROUP BY t.Name
OUTPUT
Theatre Name |
Time |
Gokul |
10:30 2:30 6:30 9:30 |
Satyam |
10:30 2:30 6:30 |