How to merge one column values by grouping another column using FOR XML PATH in SQL Server

Question

This is my tableTheatre NameTimeGokul1030 Gokul230Gokul630Gokul903Satyam1030Satyam230Satyam630I Want like thisTheatre NameTimeGokul1030  230  630  903Satyam1030  230  630  903

AnandM · Accepted Answer

HiRefer below SQL Query Sample which full fill your requirementSQLDECLARE Theatre AS TABLEName VARCHAR50Time VARCHAR50INSERT INTO Theatre NameTime SELECT 39Gokul39 39103039INSERT INTO Theatre NameTime SELECT 39Gokul39 3923039INSERT INTO Theatre NameTime SELECT 39Gokul39 3963039INSERT INTO Theatre NameTime SELECT 39Gokul39 3993039INSERT INTO Theatre NameTime SELECT 39Satyam39 39103039INSERT INTO Theatre NameTime SELECT 39Satyam39 3923039INSERT INTO Theatre NameTime SELECT 39Satyam39 3963039SELECT tName as Theatre Name        SELECT 39 39  t1Time          FROM Theatre t1          WHERE t1Name  tName                         FOR XML PATH3939 TimeFROM Theatre tGROUP BY tNameOUTPUTTheatre NameTimeGokul1030 230 630 930Satyam1030 230 630

How to merge one column values by grouping another column using FOR XML PATH in SQL Server

Company

Explore

Follow us

Contact Us

Theatre Name	Time
Gokul	10:30
Gokul	2:30
Gokul	6:30
Gokul	9:03
Satyam	10:30
Satyam	2:30
Satyam	6:30