USP_USAGEREPORT_GENERALREPORTDATA

            create procedure dbo.USP_USAGEREPORT_GENERALREPORTDATA
            (
                @ID nvarchar(36)
            )
            with execute as owner
            as
            set nocount on;

            declare @TABLENAME nvarchar(128);
            declare @SQL nvarchar(150);

            begin try
                select 
                    @TABLENAME = BUSINESSPROCESSOUTPUT.TABLENAME
                from 
                    dbo.BUSINESSPROCESSOUTPUT
                where 
                    BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = @ID and 
                    BUSINESSPROCESSOUTPUT.TABLEKEY = 'REPORTDATA';

                if not @TABLENAME is null and not OBJECT_ID(@TABLENAME) is null
                    begin
                        set @SQL = 'select * from dbo.[' + @TABLENAME + ']';
                    end
                else
                    begin
                        set @TABLENAME = 'Unable to find report data table named ' + @TABLENAME + '.'
                        raiserror(@TABLENAME, 13, 1)
                    end

                exec sp_executesql @SQL;
            end try

            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;