SQL Server 2017

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

CREATE TABLE Sigeri(
Id_Colaborador INT,
Nombre_Colaborador VARCHAR(50),
Id_Unidad_Organizativa INT,
Fecha_Registro DATE,
Hora_Registro TIME
)
INSERT INTO Sigeri VALUES(1,'E',1,GETDATE(),GETDATE())
INSERT INTO Sigeri VALUES(2,'E',2,DATEADD(DAY,1,GETDATE()),DATEADD(DAY,1,GETDATE()))-- Un dia mas
INSERT INTO Sigeri VALUES(3,'E',3,DATEADD(DAY,2,GETDATE()),DATEADD(DAY,2,GETDATE()))-- Un dia mas
3 rows affected

DECLARE @SQLDynamic NVARCHAR(MAX)



SELECT @SQLDynamic=COALESCE(@SQLDynamic+',','')+'['+CAST(Fecha_Registro    AS nvarchar(20))+']' 
FROM Sigeri  --Obtenemos los registros 
GROUP BY Fecha_Registro

DECLARE @SQLFULL NVARCHAR(MAX)='

select * from
(
select 
Id_Colaborador,
Nombre_Colaborador,
Id_Unidad_Organizativa,
Fecha_Registro,
Hora_Registro
from Sigeri
)s
pivot(
    max(Hora_Registro)
    for[Fecha_Registro] in --(select Fecha_Registro FROM Sigeri)
('+@SQLDynamic+') --Le pasamos los registros
)p'


EXEC(@SQLFULL)


Id_Colaborador
Nombre_Colaborador
Id_Unidad_Organizativa
2019-12-05
2019-12-06
2019-12-07


1
E
1
04:16:41.0866667
null
null

2
E
2
null
04:16:41.0866667
null

3
E
3
null
null
04:16:41.0866667

Id_Colaborador	Nombre_Colaborador	Id_Unidad_Organizativa	2019-12-05	2019-12-06	2019-12-07
1	E	1	04:16:41.0866667	null	null
2	E	2	null	04:16:41.0866667	null
3	E	3	null	null	04:16:41.0866667