USP_REPORT_RE7INTEGRATIONGIVINGSUMMARYCONTROLREPORT

Returns the data necessary for the RE7 Integration Giving Summary Batch Control report.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_REPORT_RE7INTEGRATIONGIVINGSUMMARYCONTROLREPORT(@BATCHID uniqueidentifier)
            with execute as owner
            as
                set nocount on;

                declare @SQL nvarchar(1000);
                set @SQL = N'
                    set nocount on;            
                    select
                        ID,
                        TOTALGIFTSGIVEN,
                        TOTALGIFTAMOUNT,    
                        CONSTITUENTNAME,
                        LOOKUPID
                    from
                        dbo.' + dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 0) + N' 
                    order by
                        KEYNAME, FIRSTNAME, MIDDLENAME;
                ';

                exec sp_executesql @SQL;