CREATE PROCEDURE [dbo].[usp_gecenyil_satislar] 
	@productId int, @ambar int 
AS
BEGIN
	DECLARE @toplam float;
	DECLARE @satislar float;
	DECLARE @iadeler float;
	SET NOCOUNT ON;
	SET @iadeler = ISNULL((SELECT SUM(AMOUNT) FROM LG_011_07_STLINE WHERE CANCELLED=0 AND SOURCEINDEX=CONVERT(INT,@ambar) AND INVOICEREF<>0 AND TRCODE=3 AND STOCKREF=CONVERT(INT, @productId) AND LINETYPE=0),0)
	SET @satislar = ISNULL((SELECT SUM(AMOUNT) FROM LG_011_07_STLINE WHERE CANCELLED=0 AND SOURCEINDEX=CONVERT(INT,@ambar) AND INVOICEREF<>0 AND TRCODE=8 AND STOCKREF=CONVERT(INT, @productId) AND LINETYPE=0),0)
    SET @toplam = @satislar-@iadeler;
	IF (@toplam <= 0.0)
	BEGIN
	RETURN 0
	END
	ELSE 
	BEGIN
	RETURN @toplam
	END
END