Facebook
From Idiotic Treeshrew, 3 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 306
  1. INSERT INTO Veritabani2.[dbo].[Siparisler]
  2. ([FaturaBaslik]
  3. ,[FaturaNumarasi]
  4. ,[FaturaTarihi]
  5.  
  6.  
  7. SELECT
  8. FaturaBaslik
  9. , FaturaNumarasi
  10. , FaturaTarihi
  11. FROM Faturalar
  12. WHERE FaturaTarihi= CONVERT(varchar(10),GETDATE(),120)
  13. AND SubeKodu = 'A01'
  14. AND Iptal = '0'
  15. AND trInvoiceLine.ItemCode NOT IN ('kargo','KargoKapida')
  16. ORDER BY CurrAccDescription
captcha