USP_DONOR_INFO_HELPER_HANDLESTANDARDCOMMITMENT

Parameters

Parameter	Parameter Type	Mode
@TRANTYPECODE	tinyint	IN
@TRANSACTIONTYPEOPTIONCODE	tinyint	IN
@FILTERCRITERIA	nvarchar(1000)	IN
@FROM	datetime	IN
@TO	datetime	IN
@REVENUEFILTERID	uniqueidentifier	IN

Definition

Copy


create procedure [dbo].[USP_DONOR_INFO_HELPER_HANDLESTANDARDCOMMITMENT] (
  @TRANTYPECODE tinyint
  ,@TRANSACTIONTYPEOPTIONCODE tinyint
  ,@FILTERCRITERIA nvarchar(1000)
  ,@FROM datetime
  ,@TO as datetime
  ,@REVENUEFILTERID uniqueidentifier
  )
  with execute as owner
as
set nocount on;

declare @SQL nvarchar(max) = ''

if isnull(@TRANSACTIONTYPEOPTIONCODE, @TRANTYPECODE) = @TRANTYPECODE
begin
  exec dbo.[USP_DONOR_INFO_HELPER_BUILDTRANSQL] @TRANTYPECODE
    ,@FILTERCRITERIA
    ,@SQL output

  exec dbo.[USP_DONOR_INFO_HELPER_ADDTORESULTS] @SQL
    ,@FROM
    ,@TO
    ,@REVENUEFILTERID;
end