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