SQL Server 2014

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288) - 12.0.6372.1 (X64) 
 Dec 12 2019 15:14:11 
 Copyright (c) Microsoft Corporation
 Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 17763: ) (Hypervisor)



create table tab (Issue int, Subject varchar(10), typ varchar(10), Team varchar(10), SubTeam varchar(20), Client varchar(10), Priority int, CreatedOn varchar(20), Label varchar(20), BuiltOn varchar(10), CreatedBy varchar(10), Status varchar(10));
insert into tab  (Issue, Subject, typ, Team , SubTeam , Client , Priority, CreatedOn , Label , BuiltOn , CreatedBy , Status )
 values (1, 'ABCABC', 'Bug', 'Develop', 'Automation', 'Andy', 0, '2021-01-11 00:00:00', 'Enhancement', 'None', 'John', 'InProgress'),
(2, 'DEFDEF', 'Bug', 'Develop', 'Automation', 'Judy', 0, '2021-01-10 00:00:00', 'Feature', 'None', 'Andre', 'New'),
(3, 'HIGHIG', 'Bug', 'Develop', 'Testing123', 'Cathy', 2, '2021-02-11 00:00:00', 'Feature', 'None', 'Keith', 'New'),
(3, 'HIGHIG', 'Bug', 'Develop', 'Testing123', 'Cathy', 2, '2021-02-11 00:00:00', 'Internal', 'None', 'Keith', 'New'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Jack', 1, '2021-05-11 00:00:00', 'Enhancement', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Jack', 1, '2021-05-11 00:00:00', 'Internal', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Larry', 1, '2021-05-11 00:00:00', 'Enhancement', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Larry', 1, '2021-05-11 00:00:00', 'Internal', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Colin', 1, '2021-05-11 00:00:00', 'Enhancement', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Colin', 1, '2021-05-11 00:00:00', 'Internal', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Nitin', 1, '2021-05-11 00:00:00', 'Enhancement', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Nitin', 1, '2021-05-11 00:00:00', 'Internal', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Lisa', 1, '2021-05-11 00:00:00', 'Enhancement', 'None', 'Maya', 'Analysis'),
(4, 'XYZXYZ', 'Bug', 'Develop', 'Automation', 'Lisa', 1, '2021-05-11 00:00:00', 'Internal', 'None', 'Maya', 'Analysis');
14 rows affected

SELECT * FROM tab;


Issue
Subject
typ
Team
SubTeam
Client
Priority
CreatedOn
Label
BuiltOn
CreatedBy
Status


1
ABCABC
Bug
Develop
Automation
Andy
0
2021-01-11 00:00:00
Enhancement
None
John
InProgress

2
DEFDEF
Bug
Develop
Automation
Judy
0
2021-01-10 00:00:00
Feature
None
Andre
New

3
HIGHIG
Bug
Develop
Testing123
Cathy
2
2021-02-11 00:00:00
Feature
None
Keith
New

3
HIGHIG
Bug
Develop
Testing123
Cathy
2
2021-02-11 00:00:00
Internal
None
Keith
New

4
XYZXYZ
Bug
Develop
Automation
Jack
1
2021-05-11 00:00:00
Enhancement
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Jack
1
2021-05-11 00:00:00
Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Larry
1
2021-05-11 00:00:00
Enhancement
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Larry
1
2021-05-11 00:00:00
Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Colin
1
2021-05-11 00:00:00
Enhancement
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Colin
1
2021-05-11 00:00:00
Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Nitin
1
2021-05-11 00:00:00
Enhancement
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Nitin
1
2021-05-11 00:00:00
Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Lisa
1
2021-05-11 00:00:00
Enhancement
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Lisa
1
2021-05-11 00:00:00
Internal
None
Maya
Analysis


WITH tmp AS (SELECT * FROM tab)
SELECT A.Issue,
       A.Client,
       STUFF((
           SELECT ', ' + B.Label 
             FROM tmp B 
            WHERE ISNULL(B.Issue, '') = ISNULL(A.Issue, '')
              AND ISNULL(B.Client, '') = ISNULL(A.Client, '')
         ORDER BY B.Issue 
          FOR XML PATH('')), 1, 2, ''
    ) AS Label
FROM
    tmp A
GROUP BY 
    A.Issue, A.Client


Issue
Client
Label


1
Andy
Enhancement

2
Judy
Feature

3
Cathy
Feature, Internal

4
Colin
Enhancement, Internal

4
Jack
Enhancement, Internal

4
Larry
Enhancement, Internal

4
Lisa
Enhancement, Internal

4
Nitin
Enhancement, Internal


WITH tmp AS (SELECT * FROM tab)
SELECT C.Issue,
       C.Subject,
       C.typ, 
       C.Team, 
       C.Subteam,
       C.Client,
       C.Priority,
       C.CreatedOn,
       D.Label,
       C.BuiltOn,
       C.CreatedBy,
       C.Status 
  FROM (SELECT tmp.*, 
               row_number() OVER (PARTITION BY Issue, Client ORDER BY Issue) as rn
        FROM tmp) C
 JOIN (SELECT A.Issue,
              A.Client,
               STUFF((
                   SELECT ', ' + B.Label 
                     FROM tmp B 
                    WHERE ISNULL(B.Issue, '') = ISNULL(A.Issue, '')
                      AND ISNULL(B.Client, '') = ISNULL(A.Client, '')
                 ORDER BY B.Issue 
                  FOR XML PATH('')), 1, 2, ''
            ) AS Label
        FROM tmp A
        GROUP BY A.Issue, A.Client) D
   ON C.Issue = D.Issue AND C.Client = D.Client AND C.rn = 1


Issue
Subject
typ
Team
Subteam
Client
Priority
CreatedOn
Label
BuiltOn
CreatedBy
Status


1
ABCABC
Bug
Develop
Automation
Andy
0
2021-01-11 00:00:00
Enhancement
None
John
InProgress

2
DEFDEF
Bug
Develop
Automation
Judy
0
2021-01-10 00:00:00
Feature
None
Andre
New

3
HIGHIG
Bug
Develop
Testing123
Cathy
2
2021-02-11 00:00:00
Feature, Internal
None
Keith
New

4
XYZXYZ
Bug
Develop
Automation
Colin
1
2021-05-11 00:00:00
Enhancement, Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Jack
1
2021-05-11 00:00:00
Enhancement, Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Larry
1
2021-05-11 00:00:00
Enhancement, Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Lisa
1
2021-05-11 00:00:00
Enhancement, Internal
None
Maya
Analysis

4
XYZXYZ
Bug
Develop
Automation
Nitin
1
2021-05-11 00:00:00
Enhancement, Internal
None
Maya
Analysis

Issue	Subject	typ	Team	SubTeam	Client	Priority	CreatedOn	Label	BuiltOn	CreatedBy	Status
1	ABCABC	Bug	Develop	Automation	Andy	0	2021-01-11 00:00:00	Enhancement	None	John	InProgress
2	DEFDEF	Bug	Develop	Automation	Judy	0	2021-01-10 00:00:00	Feature	None	Andre	New
3	HIGHIG	Bug	Develop	Testing123	Cathy	2	2021-02-11 00:00:00	Feature	None	Keith	New
3	HIGHIG	Bug	Develop	Testing123	Cathy	2	2021-02-11 00:00:00	Internal	None	Keith	New
4	XYZXYZ	Bug	Develop	Automation	Jack	1	2021-05-11 00:00:00	Enhancement	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Jack	1	2021-05-11 00:00:00	Internal	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Larry	1	2021-05-11 00:00:00	Enhancement	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Larry	1	2021-05-11 00:00:00	Internal	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Colin	1	2021-05-11 00:00:00	Enhancement	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Colin	1	2021-05-11 00:00:00	Internal	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Nitin	1	2021-05-11 00:00:00	Enhancement	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Nitin	1	2021-05-11 00:00:00	Internal	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Lisa	1	2021-05-11 00:00:00	Enhancement	None	Maya	Analysis
4	XYZXYZ	Bug	Develop	Automation	Lisa	1	2021-05-11 00:00:00	Internal	None	Maya	Analysis