Logo Destek

Database => SQL => Konuyu başlatan: ugurylmz2121 - 18.05.2020, 11:51

Başlık: Mssql kolon toplama
Gönderen: ugurylmz2121 - 18.05.2020, 11:51

Merhaba arkadaşlar, aşağıdaki kodun çıktısı resimdeki gibidir. Ben sadece TUTAR kısmının tamamını toplayıp ekrana yazdırmak istiyorum. Yardım ederseniz sevinirim tşkler.
(https://cdn.r10.net/editor/75341/241331929.png)

Kod: [Seç]

SELECT ITM.CODE,ITM.PRODUCERCODE,ITM.NAME,TOT.ONHAND MIKTAR,(CASE WHEN TOT.INVENNO='0' THEN 'ÜRETİM'
WHEN TOT.INVENNO='1' THEN 'HMF'
WHEN TOT.INVENNO='3' THEN 'TEMSA'
WHEN TOT.INVENNO='-1' THEN 'TÜM AMBARLAR' END)AS AMBAR,
(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT
FROM LG_300_01_STLINE
WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND
LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) FİYATI,
TOT.ONHAND*(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT FROM LG_300_01_STLINE
WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND
LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) TUTAR
FROM LV_300_01_GNTOTST TOT INNER JOIN LG_300_ITEMS ITM ON ITM.LOGICALREF=TOT.STOCKREF WHERE TOT.INVENNO='1'

Başlık: Ynt: Mssql kolon toplama
Gönderen: mbakitkal - 22.06.2020, 10:56

Select SUM(TUTAR) Toplam_Tutar
from (
SELECT ITM.CODE,ITM.PRODUCERCODE,ITM.NAME,TOT.ONHAND MIKTAR,(CASE WHEN TOT.INVENNO='0' THEN 'ÜRETİM'
WHEN TOT.INVENNO='1' THEN 'HMF'
WHEN TOT.INVENNO='3' THEN 'TEMSA'
WHEN TOT.INVENNO='-1' THEN 'TÜM AMBARLAR' END)AS AMBAR,
(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT
FROM LG_300_01_STLINE
WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND
LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) FİYATI,
TOT.ONHAND*(SELECT TOP 1 (TOTAL-DISTCOST)/AMOUNT FROM LG_300_01_STLINE
WHERE STOCKREF=ITM.LOGICALREF AND (TRCODE=1 or (TRCODE=14 and BILLED=0) )AND
LPRODSTAT=0 AND LINETYPE=0 ORDER BY DATE_ DESC ) TUTAR
FROM LV_300_01_GNTOTST TOT INNER JOIN LG_300_ITEMS ITM ON ITM.LOGICALREF=TOT.STOCKREF WHERE TOT.INVENNO='1' ) Hepsi