Go ile kullanmiyorum fakat sanirim su query sene yardim olur....
SELECT I.CODE [ Kod], I.NAME [Aciklama], B.CODE [Birim], I.CYPHCODE [Firma],
SUM(CASE WHEN S.MONTH_=6 THEN CASE S.TRCODE WHEN 7 THEN 1 WHEN 2 THEN -1 ELSE 0 END * S.AMOUNT END) [Iyun Miktar],
SUM(CASE WHEN S.MONTH_=7 THEN CASE S.TRCODE WHEN 7 THEN 1 WHEN 2 THEN -1 ELSE 0 END * S.AMOUNT END) [Iyul Miktar],
SUM(CASE WHEN S.MONTH_=8 THEN CASE S.TRCODE WHEN 7 THEN 1 WHEN 2 THEN -1 ELSE 0 END * S.AMOUNT END) [Avgust Miktar],
SUM(CASE WHEN S.MONTH_=9 THEN CASE S.TRCODE WHEN 7 THEN 1 WHEN 2 THEN -1 ELSE 0 END * S.AMOUNT END) [Sentyabr Miktar]
FROM LG_XXX_ITEMS AS I INNER JOIN LG_XXX_UNITSETF AS B ON I.UNITSETREF=B.LOGICALREF INNER JOIN LG_XXX_01_STLINE AS S ON I.LOGICALREF=S.STOCKREF
WHERE S.LINETYPE='0' AND S.TRCODE IN (7,2)
GROUP BY I.CODE, I.NAME, B.CODE, I.CYPHCODE
Perakende satis faturalari icin...
Topdan faturalari icin Fatura turu (7,2)-ni (8,3)-ile evez etsen olur
