I would like to do a PIVOT
on my table but I don’t have aggregation column.
SELECT
CONVERT(date, DataHora) AS dia,
CONVERT(VARCHAR(5), DataHora, 108) AS hora
FROM
[clientes].[dbo].[Tb_Ponto]
Result:
2021-12-27 12:41
2021-12-28 12:42
2021-12-28 13:03
2021-12-28 14:08
I would like it to stay like this:
2021-12-27 12:41 | NULL | NULL
2021-12-28 12:42 | 13:03 | 14:08