Sorgunuzun son güncel hali.
SELECT
CARİ.CODE AS [KODU],
CARİ.CITY AS [ŞEHİR],
CARİ.DEFINITION_ AS [ÜNVANI],
MLZ.NAME AS [ÜRÜN],
FAT.FICHENO as [FİŞ NO],
STL.DATE_ AS [TARİH],
CASE When stl.DISTDISC>0 THEN 'İsk Uyg.' ELSE 'Liste' end AS [DURUM],
STL.AMOUNT AS [MİKTAR],
ISNULL(STL.LINENET/NULLIF(STL.AMOUNT,0),0) AS [SATIŞ FIYAT],
(SELECT TOP 1 PRICE FROM LG_017_01_STLINE WHERE STOCKREF = MLZ.LOGICALREF AND CANCELLED=0 AND (TRCODE = 1 OR (TRCODE = 14 AND BILLED = 0)) AND LPRODSTAT = 0 AND LINETYPE = 0 ORDER BY DATE_ DESC,FTIME DESC) AS [Son Alış],
(STl.LINENET) as [SATIŞ TOPLAMI],
(STL.AMOUNT*(SELECT TOP 1 PRICE FROM LG_017_01_STLINE WHERE STOCKREF = MLZ.LOGICALREF AND CANCELLED=0 AND (TRCODE = 1 OR (TRCODE = 14 AND BILLED = 0)) AND LPRODSTAT = 0 AND LINETYPE = 0 ORDER BY DATE_ DESC,FTIME DESC)) AS [ ALIŞ NET TOPLAM],
ROUND(ISNULL(((STL.LINENET)/NULLIF(STL.AMOUNT*(SELECT TOP 1 PRICE FROM LG_017_01_STLINE WHERE STOCKREF = MLZ.LOGICALREF AND CANCELLED=0 AND (TRCODE = 1 OR (TRCODE = 14 AND BILLED = 0)) AND LPRODSTAT = 0 AND LINETYPE = 0 ORDER BY DATE_ DESC,FTIME DESC),0 )-1),0),2) * 100 AS [KAR ORAN]
FROM
LG_017_01_STLINE AS STL,
LG_017_CLCARD as CARİ,
LG_017_ITEMS AS MLZ,
LG_017_01_INVOICE AS FAT,
LG_017_PRCLIST AS PRC WHERE
STL.CLIENTREF = CARİ.LOGICALREF
AND
STL.STOCKREF = MLZ.LOGICALREF
AND
STL.INVOICEREF = FAT.LOGICALREF
AND
PRC.CARDREF = MLZ.LOGICALREF AND stl.CANCELLED=0 AND
(STL.TRCODE=8)AND STL.BILLED=1 AND (STL.DATE_ BETWEEN CONVERT(DATETIME,'01.01.2017',104) AND CONVERT(DATETIME,'31.12.2017',104))
