set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create FUNCTION [dbo].[FunGoodRemainBeforeDate] ( @Date char(8)='99/99/99' ) RETURNS TABLE AS RETURN SELECT GoodSysCode, SUM(NetQuantity) AS Remain FROM VWInvoiceDetailComplete WHERE (NOT (FK_DocsysCode IS NULL)) AND (InvoiceDate < @Date) OR (Amani = 1) AND (InvoiceDate < @Date) GROUP BY GoodSysCode