[dbo].[RevenueRatingImportInvoiceDetailUpdateAgent]
CREATE PROCEDURE [dbo].[RevenueRatingImportInvoiceDetailUpdateAgent]
@inRevenueRatingImportInvoiceDetailID int,
@inAgentID int,
@inImported bit
AS
set nocount on
if( @inImported = 0 )
begin
update RevenueRatingImportInvoiceDetail set AgentFID = @inAgentID where RevenueRatingImportInvoiceDetailID = @inRevenueRatingImportInvoiceDetailID
end
else
begin
update RevenueRatingImportedInvoiceDetail set AgentFID = @inAgentID where RevenueRatingImportedInvoiceDetailID = @inRevenueRatingImportInvoiceDetailID
end
GO
GRANT EXECUTE ON [dbo].[RevenueRatingImportInvoiceDetailUpdateAgent] TO [MssExec]
GO