GROUP BY CLNTC.DEFINITION_,STRNS.DATE_
kullandığımızda her faturayı ayırıp öyle veriyor
1.cari miktar tutarı fatura tarihi
1.cari miktar tutarı fatura tarihi
2. cari miktar tutarı fatura tarihi
2. cari miktar tutarı fatura tarihi
gibi. aşağıdaki gibi her carinin toplamı isteniyor...
verdiğiniz aşağıdaki sorguya tarih alanı değilde tarih filtresi eklesem tamam..
SELECT CLNTC.DEFINITION_ AS [CARİ ÜNVANI], SUM(STRNS.AMOUNT) AS [TOPLAM],SUM(STRNS.TOTAL) AS [TUTAR],
CAST((SELECT SUM(TOTAL) FROM LG_017_01_STLINE WHERE TRCODE=8 AND SOURCEINDEX IN (0, 1, 2, 3, 4) AND LINETYPE IN (2,3) AND CANCELLED=0 AND CPSTFLAG<>1 ) / SUM(STRNS.TOTAL) AS DECIMAL(18,0)) AS ORAN
FROM
dbo.LG_017_01_STLINE AS STRNS WITH (NOLOCK) LEFT OUTER JOIN
dbo.LG_017_CLCARD AS CLNTC WITH (NOLOCK) ON STRNS.CLIENTREF = CLNTC.LOGICALREF LEFT OUTER JOIN
dbo.LG_017_ITEMS AS ITMSC WITH (NOLOCK) ON STRNS.STOCKREF = ITMSC.LOGICALREF
WHERE (STRNS.SOURCEINDEX IN (0, 1, 2, 3, 4)) AND
(STRNS.CPSTFLAG <> 1) AND (STRNS.DETLINE <> 1) AND (STRNS.LINETYPE NOT IN (2, 3)) AND (STRNS.TRCODE IN (
) AND (STRNS.CANCELLED = 0)
GROUP BY CLNTC.DEFINITION_
ORDER BY SUM(STRNS.AMOUNT) DESC