INSERT INTO Veritabani2.[dbo].[Siparisler]
([FaturaBaslik]
,[FaturaNumarasi]
,[FaturaTarihi]


SELECT
FaturaBaslik
, FaturaNumarasi
, FaturaTarihi
FROM Faturalar
WHERE FaturaTarihi= CONVERT(varchar(10),GETDATE(),120)
AND SubeKodu = 'A01'
AND Iptal = '0'
AND trInvoiceLine.ItemCode NOT IN ('kargo','KargoKapida')
ORDER BY CurrAccDescription