1 AUrun 10 AFirma
2 AUrun 11 BFirma
3 AUrun 12 CFirma
4 BUrun 9 AFirma
5 BUrun 8 CFirma
6 CUrun 15 BFirma
7 CUrun 14 CFirma
8 DUrun 18 AFirma
NULL NULL NULL NULL
select
Urun
, [1] = max(case when RowID = 1 then Firma +' ('+Cast(Teklif as nvarchar)+') ' end)
, [2] = max(case when RowID = 2 then Firma +' ('+Cast(Teklif as nvarchar)+') ' end)
, [3] = max(case when RowID = 3 then Firma +' ('+Cast(Teklif as nvarchar)+') ' end)
, [4] = max(case when RowID = 4 then Firma +' ('+Cast(Teklif as nvarchar)+') ' end)
from (
select
Urun
, Firma
, Teklif
, RowID = row_number() over (partition by Urun order by Teklif desc)
from [YKMTravelPortal].[dbo].[tempTablo]
) SourceTable
group by
Urun
===================
