use tempdb
DECLARE @TABLE TABLE
(
ID INT IDENTITY(1,1),
DEGER NVARCHAR(200)
)
INSERT INTO @TABLE (DEGER)
VALUES ('ferhat acar / 14.03.2023 / 08:00 17:00'),
('ferhat acar / 16.03.2023 / 08:00 17:00')
;WITH DETAY AS
(
SELECT T.C.value('.', 'NVARCHAR(MAX)') AS ISIM,A.ID,ROW_NUMBER() OVER (PARTITION BY A.ID ORDER BY A.ID) SIRA
FROM (SELECT CAST('' + REPLACE(DEGER,'/','') + '' AS XML) AS X,ID FROM @TABLE ) AS A
CROSS APPLY X.nodes ('/C') AS T(C)
), DETAYLI AS(
SELECT t.ID,T.DEGER,ADI.ISIM AS [İsim],TARIH.ISIM as [Tarih],SAAT.ISIM as [Saat] FROM @TABLE AS T
CROSS APPLY(SELECT * FROM DETAY A WHERE A.ID = T.ID AND A.SIRA=1 ) AS ADI
CROSS APPLY(SELECT * FROM DETAY A WHERE A.ID = T.ID AND A.SIRA=2 ) AS TARIH
CROSS APPLY(SELECT * FROM DETAY A WHERE A.ID = T.ID AND A.SIRA=3 ) AS SAAT)
SELECT k.İsim+' / '+MAX(k.Tarih)+' / '+max(saat.Saat) Tarih
FROM DETAYLI k
outer apply (select * from DETAYLI as g where g.İsim=k.İsim and g.Tarih=(k.Tarih) ) as saat
GROUP BY k.İsim