SELECT CONVERT(VARCHAR(50),INV.DATE_,104), SUM(INV.GROSSTOTAL), CL.CODE, INV.FICHENO FROM LG_003_CLCARD CL JOIN LG_003_03_INVOICE INV ON IN...
Okumaya devam et
SELECT BARKOD.ITMUNITAREF, ORL.ORDFICHEREF FisRef, BARKOD.BARCODE Barkod, IT.NAME Malzeme_Aciklamasi, ORL.AMOUNT Siparis_Miktar, UNT.NAME Birimsetiad...
Okumaya devam et
SELECT FICHENO ,"Seq"=CASE WHEN LEN(ConverT(nvarchar(50),ROW_NUMBER() OVER (ORDER BY DATE_,LOGICALREF)))=1 THEN 'ARV201700000000'+Conv...
Okumaya devam et
SELECT FICHENO ,"Seq"=CASE WHEN LEN(ConverT(nvarchar(50),ROW_NUMBER() OVER (ORDER BY DATE_,LOGICALREF)))=1 THEN 'ARV201700000000'+Conv...
Okumaya devam et
<blockquote> <p><span style="font-size:12pt"><span style="font-family:"Times New Roman","serif""><span style="font-size:10.5pt"><s...
Okumaya devam et
SELECT VR.CODE, VR.NAME, EM.CODE, (CASE CR.TYP WHEN 1 THEN 'ALIMLAR HESABI' WHEN 2 THEN 'DİĞER GİRİŞLER' WHEN 3 THEN 'SATIŞLAR HESABI' WHEN 4 THEN 'Dİ...
Okumaya devam et