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