USP_REPORT_INTERACTIONBATCHCONTROLREPORT

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN
Definition

Copy

                create procedure dbo.USP_REPORT_INTERACTIONBATCHCONTROLREPORT
                (
                    @BATCHID uniqueidentifier
                )
                with execute as owner
                as
                    declare @TABLENAME nvarchar(128);

                    set nocount on;

                    select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 0)

                    declare @SQLTOEXEC nvarchar(500);

                    set @SQLTOEXEC = N'set nocount on;
                        select 
                            ID, 
                            CONSTITUENTNAME, 
                            OWNERNAME, 
                            OBJECTIVE, 
                            STATUS, 
                            CONTACTMETHOD,
                            DATE
                        from 
                            dbo.' + @TABLENAME;

                    exec sp_executesql @SQLTOEXEC;