SQL Server 2022

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

-- Create table
CREATE TABLE mytable
(
    TT int,
    ID varchar(20),
    No int,
    Date_input date,
    BR int
);

-- Insert data
INSERT INTO mytable (TT, ID, No, Date_input, BR)
VALUES
(1, '06041098', 780000, '01/01/2015', 111),
(2, '01506000299', 780000, '11/07/2022', 111),
(1, '06048903', 783111, '01/01/2015', 123),
(2, '015173000562', 783111, '04/25/2023', 123),
(1, '01517300', 792523, '02/02/2022', 150),
(2, '011105981', 792523, '03/21/2022', 150),
(3, '0346166413164', 792523, '04/25/2023', 150);
7 rows affected

select 
  [No], BR, ID, Date_input, TT
from mytable
order by [No], BR, TT


No
BR
ID
Date_input
TT


780000
111
06041098
2015-01-01
1

780000
111
01506000299
2022-11-07
2

783111
123
06048903
2015-01-01
1

783111
123
015173000562
2023-04-25
2

792523
150
01517300
2022-02-02
1

792523
150
011105981
2022-03-21
2

792523
150
0346166413164
2023-04-25
3


-- Traditional Pivot query using conditional aggregates
SELECT No AS NoB,
       BR,
       MAX(CASE WHEN TT = 1 THEN ID END) AS ID1,
       MAX(CASE WHEN TT = 1 THEN Date_input END) AS Date_input1,
       MAX(CASE WHEN TT = 2 THEN ID END) AS ID2,
       MAX(CASE WHEN TT = 2 THEN Date_input END) AS Date_input2,
       MAX(CASE WHEN TT = 3 THEN ID END) AS ID3,
       MAX(CASE WHEN TT = 3 THEN Date_input END) AS Date_input3
FROM   mytable
GROUP BY No, BR;


NoB
BR
ID1
Date_input1
ID2
Date_input2
ID3
Date_input3


780000
111
06041098
2015-01-01
01506000299
2022-11-07
null
null

783111
123
06048903
2015-01-01
015173000562
2023-04-25
null
null

792523
150
01517300
2022-02-02
011105981
2022-03-21
0346166413164
2023-04-25


Warning: Null value is eliminated by an aggregate or other SET operation.


-- Traditional Pivot query using conditional aggregates
SELECT NoB,
       BR,
       MAX(CASE WHEN Col1 = 'ID1' THEN ID END) AS ID1,
       MAX(CASE WHEN Col2 = 'Date_input1' THEN Date_input END) AS Date_input1,
       MAX(CASE WHEN Col1 = 'ID2' THEN ID END) AS ID2,
       MAX(CASE WHEN Col2 = 'Date_input2' THEN Date_input END) AS Date_input2,
       MAX(CASE WHEN Col1 = 'ID3' THEN ID END) AS ID3,
       MAX(CASE WHEN Col2 = 'Date_input3' THEN Date_input END) AS Date_input3
FROM (
    SELECT No AS NoB,
           BR,
           ID,
           Date_input,
           CONCAT('ID', TT) AS Col1,
           CONCAT('Date_input', TT) AS Col2
    FROM mytable
  ) AS d
GROUP BY NoB, BR;


NoB
BR
ID1
Date_input1
ID2
Date_input2
ID3
Date_input3


780000
111
06041098
2015-01-01
01506000299
2022-11-07
null
null

783111
123
06048903
2015-01-01
015173000562
2023-04-25
null
null

792523
150
01517300
2022-02-02
011105981
2022-03-21
0346166413164
2023-04-25


Warning: Null value is eliminated by an aggregate or other SET operation.

No	BR	ID	Date_input	TT
780000	111	06041098	2015-01-01	1
780000	111	01506000299	2022-11-07	2
783111	123	06048903	2015-01-01	1
783111	123	015173000562	2023-04-25	2
792523	150	01517300	2022-02-02	1
792523	150	011105981	2022-03-21	2
792523	150	0346166413164	2023-04-25	3