carı hesap kodu ekleme

[Hüseyin FERAHLI]

Aşağıdaki formüle CARI HESAP KODU ekleme nasıl yapabiliriz. Kolay gelsın.



SELECT  CLNTC.DEFINITION_ 'Cari Hesap Ünvany', CLNTC.TAXOFFICE 'Vergi Dairesi', CLNTC.TAXNR 'Vergi Numarasy', SUM(XXX.LNETSUM2) AS 'KDV Hariç Tutar', SUM(XXX.FICHECOUNT2) AS 'Fiş Sayısı' FROM (SELECT INVFC.CLIENTREF, COUNT(DISTINCT INVFC.LOGICALREF) AS FICHECOUNT2, SUM((INVFC.NETTOTAL-INVFC.TOTALVAT)) AS LNETSUM2  FROM  LG_002_03_INVOICE INVFC  WITH(NOLOCK) WHERE  INVFC.STATUS = 0  AND  INVFC.TRCODE IN (6,7,8,9,10,14) AND INVFC.NETTOTAL <> 0  AND INVFC.CLIENTREF <> 0  AND INVFC.CANCELLED  = 0  AND INVFC.DATE_ >= CONVERT(dateTime, '3-1-2010', 101) AND (INVFC.DATE_ <= CONVERT(dateTime, '3-31-2010', 101)) GROUP BY INVFC.CLIENTREF) XXX LEFT OUTER JOIN LG_002_CLCARD CLNTC WITH(NOLOCK) ON (XXX.CLIENTREF  =  CLNTC.LOGICALREF) GROUP BY CLNTC.DEFINITION_,CLNTC.TAXOFFICE,CLNTC.TAXNR,CLNTC.LOGICALREF HAVING SUM(XXX.LNETSUM2) >= 5000 ORDER BY CLNTC.DEFINITION_

[hosaf]

SELECT  CLNTC.CODE 'Cari HEsap KOdu' , CLNTC.DEFINITION_ 'Cari Hesap Ünvany', CLNTC.TAXOFFICE 'Vergi Dairesi', CLNTC.TAXNR 'Vergi Numarasy', SUM(XXX.LNETSUM2) AS 'KDV Hariç Tutar', SUM(XXX.FICHECOUNT2) AS 'Fiş Sayısı' FROM (SELECT INVFC.CLIENTREF, COUNT(DISTINCT INVFC.LOGICALREF) AS FICHECOUNT2, SUM((INVFC.NETTOTAL-INVFC.TOTALVAT)) AS LNETSUM2  FROM  LG_002_03_INVOICE INVFC  WITH(NOLOCK) WHERE  INVFC.STATUS = 0  AND  INVFC.TRCODE IN (6,7,8,9,10,14) AND INVFC.NETTOTAL <> 0  AND INVFC.CLIENTREF <> 0  AND INVFC.CANCELLED  = 0  AND INVFC.DATE_ >= CONVERT(dateTime, '3-1-2010', 101) AND (INVFC.DATE_ <= CONVERT(dateTime, '3-31-2010', 101)) GROUP BY INVFC.CLIENTREF) XXX LEFT OUTER JOIN LG_002_CLCARD CLNTC WITH(NOLOCK) ON (XXX.CLIENTREF  =  CLNTC.LOGICALREF) GROUP BY CLNTC.DEFINITION_,CLNTC.TAXOFFICE,CLNTC.TAXNR,CLNTC.LOGICALREF HAVING SUM(XXX.LNETSUM2) >= 5000 ORDER BY CLNTC.DEFINITION_