set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER FUNCTION [dbo].[FunGoodAllSellByDate] 
	(
	@startDate char(8)='00/00/00',
	@EndDate char(8)='99/99/99'
	)
RETURNS TABLE
AS
	RETURN SELECT     GoodSysCode, -SUM(NetQuantity) AS NetQuantity, -SUM(Fee * NetQuantity) AS TotalAmount
FROM         VWInvoiceDetailComplete
WHERE     (Amani = 1) AND (Type = 1 OR
                      Type = 3) AND (InvoiceDate BETWEEN @startDate AND @EndDate) OR
                      (Type = 1 OR
                      Type = 3) AND (InvoiceDate BETWEEN @startDate AND @EndDate) AND (NOT (FK_DocsysCode IS NULL))
GROUP BY GoodSysCode