USP_REPORT_CURRENCYEXCHANGERATEBATCHCONTROLREPORT

                create procedure dbo.USP_REPORT_CURRENCYEXCHANGERATEBATCHCONTROLREPORT
                (
                    @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, 
                            FROMCURRENCY, 
                            TOCURRENCY, 
                            RATE, 
                            ASOFDATE,
                            TYPE, 
                            SOURCECODE
                        from 
                            dbo.' + @TABLENAME;

                    exec sp_executesql @SQLTOEXEC;