USP_REPORT_OPPORTUNITYRESERVESUCCESS

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

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

          select @TABLENAME = BUSINESSPROCESSOUTPUT.TABLENAME 
          from dbo.BUSINESSPROCESSSTATUS 
          inner join dbo.BUSINESSPROCESSOUTPUT on BUSINESSPROCESSSTATUS.ID = BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID
          where BUSINESSPROCESSSTATUS.ID = @ID
          and BUSINESSPROCESSOUTPUT.TABLEKEY = 'Success';

          if @TABLENAME is null or OBJECT_ID(@TABLENAME) is null
            raiserror('Business process exception table could not be found.  The process might not have completed successfully. ',13,1)

          begin try
            set @SQL = 'select ''http://www.blackbaud.com/SPOPPORTUNITYID?SPOPPORTUNITYID='' + CONVERT(nvarchar(36),SPO.ID) SPOPPORTUNITYID,
                       dbo.UFN_SPONSORSHIPOPPORTUNITY_TRANSLATIONFUNCTION(SPO.ID) SPOPPORTUNITY,                      
                       SPO.LOOKUPID SPOPPORTUNITYLOOKUPID
                       from dbo.' + @TABLENAME + ' SUCCESSTAB
                       inner join dbo.SPONSORSHIPOPPORTUNITY SPO on SPO.ID = SUCCESSTAB.SPOPPORTUNITYID';                
            exec sp_executesql @SQL;
          end try
          begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
          end catch

        return 0;