USP_STEWARDSHIPPACKAGEREPORT_FINANCIALINFO

            create proc dbo.USP_STEWARDSHIPPACKAGEREPORT_FINANCIALINFO(@DESIGNATIONLEVELID uniqueidentifier)
                as
                declare @SQL nvarchar(4000);
                declare @TABLE nvarchar(255);

                begin try
                    select @TABLE = BUSINESSPROCESSOUTPUT.TABLENAME 
                    from dbo.BUSINESSPROCESSOUTPUT inner join dbo.STEWARDSHIPPACKAGEPROCESSHISTORY on BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = STEWARDSHIPPACKAGEPROCESSHISTORY.BUSINESSPROCESSSTATUSGUID
                    where STEWARDSHIPPACKAGEPROCESSHISTORY.ID = @DESIGNATIONLEVELID and BUSINESSPROCESSOUTPUT.TABLEKEY = 'OUTPUT_FINANCIAL';                                    

                    set @SQL = 'select 
                                    STARTDATE,
                                    ENDDATE, 
                                    BOOKVALUESTART,
                                    BOOKVALUEEND,
                                    MARKETVALUESTART,
                                    MARKETVALUEEND,
                                    TOTALGIFTREVENUE,
                                    TOTALDISBURSEMENTS,
                                    PLEDGEBALANCE
                                from 
                                   dbo.' + @TABLE;                                                     

                    exec sp_executesql @SQL;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch