converting-rows-records-to-columns-in-mysql, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

CREATE TABLE Table_pivot_01
    ([SSN ID] int, [Citizen_name] varchar(5), [Company] varchar(4))
;
    
INSERT INTO Table_pivot_01
    ([SSN ID], [Citizen_name], [Company])
VALUES
    (12345, 'John', 'XYZ'),
    (12346, 'Tom', 'ABC'),
    (12347, 'Jerry', 'QWER'),
    (12348, 'Joe', 'PQR'),
    (12349, 'Josh', NULL)
;

CREATE TABLE Table_pivot_02
    ([Serial] int, [SSN_ID] int, [Family_details] varchar(9), [Family_members_name] varchar(10))
;
    
INSERT INTO Table_pivot_02
    ([Serial], [SSN_ID], [Family_details], [Family_members_name])
VALUES
    (1010, 12345, 'Spouse', 'Mari'),
    (1011, 12345, 'Child - 1', 'John Jr. 1'),
    (1012, 12345, 'Child - 2', 'John Jr. 2'),
    (1013, 12346, 'Spouse', 'Ken'),
    (1014, 12347, 'Spouse', 'Suzen'),
    (1015, 12347, 'Child - 1', 'Jerry Jr.1'),
    (1016, 12347, 'Child - 2', 'Jerry Jr.2'),
    (1017, 12347, 'Child - 3', 'Jerry Jr.3'),
    (1018, 12348, 'Child - 1', 'Joe Jr.1'),
    (1019, 12348, 'Child - 2', 'Joe Jr.2'),
    (1020, 12349, 'Spouse', 'Zoe'),
    (1021, 12349, 'Child - 1', 'Josh Jr.1'),
    (1022, 12349, 'Child - 2', 'Josh Jr.2')
;

CREATE TABLE Table_pivot_03
    ([Row] int, [SSN_ID] int, [Address_type] varchar(8), [Address] varchar(22), [PhoneNumber_type] varchar(6), [PhoneNumber] varchar(18))
;
    
INSERT INTO Table_pivot_03
    ([Row], [SSN_ID], [Address_type], [Address], [PhoneNumber_type], [PhoneNumber])
VALUES
    (121, 12345, 'Present', 'Address_John_Present', 'Home', 'John_Home_phone'),
    (122, 12345, 'Office', 'Address_John_Office', 'Office', 'John_Office_phone'),
    (123, 12345, 'Perement', 'Address_John_Perement', 'Fax', 'John_FAX_phone'),
    (124, 12346, 'Present', 'Address_Tom_Present', 'Home', 'Tom_Home_phone'),
    (125, 12346, 'Office', 'Address_Tom_Office', 'Office', 'Tom_Office_phone'),
    (126, 12347, 'Office', 'Address_Jerry_Office', 'Home', 'Jerry_Home_phone'),
    (127, 12347, 'Perement', 'Address_Jerry_Perement', 'Office', 'Jerry_Office_phone'),
    (128, 12348, 'Present', 'Address_Joe_Present', 'Home', 'Joe_Home_phone'),
    (129, 12348, 'Office', 'Address_Joe_Office', 'Office','Joe_Office_phone'),
    (130, 12348, 'Perement' , 'Address_Josh_Perement','','' ),
     (131, 12349, 'Present','Address_Josh_Present','Home','Josh_Home_phone'),
     (132, 12349, 'Perement', 'Address_Josh_Perement' , 'Fax' ,'Josh_FAX_phone');

select * from Table_pivot_01;
select * from Table_pivot_02;
select * from Table_pivot_03;

View schema
Execution time: 0,02 sec, rows selected: 30, rows affected: 30, absolute service time: 0,18 sec