USP_REPORT_STEWARDSHIPREPORT

            CREATE proc dbo.USP_REPORT_STEWARDSHIPREPORT (@ID uniqueidentifier = null)
            as
                declare @SQL nvarchar(4000);
                declare @TABLE nvarchar(255);
                declare @QUERYVIEWID uniqueidentifier;

                begin try
                    select
                        @TABLE = BUSINESSPROCESSOUTPUT.TABLENAME,
                        @QUERYVIEWID = QUERYVIEWCATALOGID
                    from dbo.BUSINESSPROCESSOUTPUT
                    inner join dbo.STEWARDSHIPPACKAGEPROCESSHISTORY on BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID = STEWARDSHIPPACKAGEPROCESSHISTORY.BUSINESSPROCESSSTATUSGUID
                    inner join dbo.BUSINESSPROCESSVIEW on BUSINESSPROCESSVIEW.ID = STEWARDSHIPPACKAGEPROCESSHISTORY.BUSINESSPROCESSVIEWID
                    where STEWARDSHIPPACKAGEPROCESSHISTORY.ID = @ID and BUSINESSPROCESSOUTPUT.TABLEKEY = 'OUTPUT';

                    if @QUERYVIEWID = 'A7AC0B59-C701-446D-A4A2-7BFAB2D3B2DF'
                        set @SQL = 'select 
                                        PURPOSEID as ID,
                                        PURPOSENAME as NAME,
                                        PURPOSEDESCRIPTION as DESCRIPTION,
                                        PURPOSEVANITYNAME as VANITYNAME,
                                        PURPOSESTATEMENTWORDING as STATEMENTWORDING
                                    from ' + @TABLE + ';';
                    else
                        set @SQL = 'select 
                                        ID, NAME, DESCRIPTION, VANITYNAME, STATEMENTWORDING
                                    from ' + @TABLE + ';';

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