declare @client table(id int primary key, id_doc int, FIO nvarchar(50), HB date);
declare @document table(id_doc int primary key, [date] date, [Name] nvarchar(50));

insert into @client values
(1001,2222, N'Иванов Иван Иванович','19850505'),
(1002,2222, N'Петров Иван Иванович','19860606'),
(1003,2222, N'Сидоров Иван Иванович','19870707'),
(1004,3333, N'Тестеров Иван Иванович','19880808');

insert into @document values(2222,'20190101', N'Полис страхования БЛА'),(3333,'20190131',N'ЙЦУКЕН ФЫВАПРО');

;with PData as
(
select D.id_doc, D.date, D.Name, C.Fio, C.HB, ROW_NUMBER() OVER(partition by C.id_doc order by C.HB, C.id) as N 
from @document D join @client C ON D.id_doc=C.id_doc
)

select 
	P.id_doc, P.date, P.Name,
	MAX(CASE WHEN P.N=1 THEN P.FIO ELSE NULL END) AS FIO1,
	MAX(CASE WHEN P.N=1 THEN P.HB ELSE NULL END) AS HB1,
	MAX(CASE WHEN P.N=2 THEN P.FIO ELSE NULL END) AS FIO2,
	MAX(CASE WHEN P.N=2 THEN P.HB ELSE NULL END) AS HB2,
	MAX(CASE WHEN P.N=3 THEN P.FIO ELSE NULL END) AS FIO3,
	MAX(CASE WHEN P.N=3 THEN P.HB ELSE NULL END) AS HB3
from PData P
group by P.id_doc, P.date, P.Name