1-) MSSQL RMOS - with ile sanal tablo oluştur

SELECT

Rsat_Fisno,

MIN(Rsat_Odano),

MIN(Rsat_Folio),

MIN(Rsat_Odenmez),

MAX(Cari.Cari_Ad) + ' ' + ISNULL(MAX(Cari.Cari_Soyad),'') + ' ' +MAX(Rsat_Cari)

into #FisOdano

FROM Cst_Recete_Satis as Satis WITH(NOLOCK)

LEFT OUTER JOIN Pos_Cari AS Cari WITH(NOLOCK) ON Rsat_Cari = Cari.Cari_Kod

GROUP BY Rsat_Fisno

select * from #FisOdano

 with genelde kullanma intoyu kullan

WITH FisOdano(Fisno,Odano,Folio,ROdenmez,Rsat_Cari)

as

(

SELECT

Rsat_Fisno,

MIN(Rsat_Odano),

MIN(Rsat_Folio),

MIN(Rsat_Odenmez),

MAX(Cari.Cari_Ad) + ' ' + ISNULL(MAX(Cari.Cari_Soyad),'') + ' ' +MAX(Rsat_Cari)

FROM Cst_Recete_Satis as Satis WITH(NOLOCK)

LEFT OUTER JOIN Pos_Cari AS Cari WITH(NOLOCK) ON Rsat_Cari = Cari.Cari_Kod

GROUP BY Rsat_Fisno

)

select * from FisOdano

kaynak : https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver15