set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create PROCEDURE [dbo].[STPListGoodReport2] @__GoodCode int =0 , @__PersonCode int=0, @FormCaption nvarchar(1000) output AS SELECT @FormCaption=Title + '- ' + CAST(AccountSysCode AS nvarchar(1000)) FROM CodeMNGDWNTbl WHERE (AccountSysCode = @__PersonCode) SELECT @FormCaption = @FormCaption + ' ** ' + Title + '- ' + CAST(GoodSyscode AS nvarchar(1000)) FROM StockTbl WHERE (GoodSyscode = @__GoodCode) if (@__PersonCode>0 and @__GoodCode>0) begin SELECT Quantity, Fee, UnitRate, SerialNo, InvoiceDate, InvoiceSerialNo, Size, WareHouse, Color, CustomerName, InvoiceType, AccountTitle, NetQuantity, GoodTitle, RecivedDate, Term, Comment, Unit, FK_DocsysCode, GoodSysCode, FK_AccountSysCode, Amani FROM VWGoodReport WHERE (NOT (FK_DocsysCode IS NULL)) AND (GoodSysCode = @__GoodCode) AND (FK_AccountSysCode = @__PersonCode) OR (GoodSysCode = @__GoodCode) AND (FK_AccountSysCode = @__PersonCode) AND (Amani = 1)return end if (@__GoodCode>0) begin SELECT Quantity, Fee, UnitRate, SerialNo, InvoiceDate, InvoiceSerialNo, Size, WareHouse, Color, CustomerName, InvoiceType, AccountTitle, NetQuantity, GoodTitle, RecivedDate, Term, Comment, Unit, FK_DocsysCode, GoodSysCode, FK_AccountSysCode, Amani FROM VWGoodReport WHERE (NOT (FK_DocsysCode IS NULL)) AND (GoodSysCode = @__GoodCode) OR (GoodSysCode = @__GoodCode) AND (Amani = 1) return end if (@__PersonCode>0 ) begin SELECT Quantity, Fee, UnitRate, SerialNo, InvoiceDate, InvoiceSerialNo, Size, WareHouse, Color, CustomerName, InvoiceType, AccountTitle, NetQuantity, GoodTitle, RecivedDate, Term, Comment, Unit, FK_DocsysCode, GoodSysCode, FK_AccountSysCode, Amani FROM VWGoodReport WHERE (NOT (FK_DocsysCode IS NULL)) AND (FK_AccountSysCode = @__PersonCode) OR (FK_AccountSysCode = @__PersonCode) AND (Amani = 1) return end SELECT Quantity, Fee, UnitRate, SerialNo, InvoiceDate, InvoiceSerialNo, Size, WareHouse, Color, CustomerName, InvoiceType, AccountTitle, NetQuantity, GoodTitle, RecivedDate, Term, Comment, Unit, FK_DocsysCode, GoodSysCode, FK_AccountSysCode, Amani FROM VWGoodReport WHERE (NOT (FK_DocsysCode IS NULL)) OR (Amani = 1)