USP_REPORT_PROSPECTASSIGNMENTPROCESS_PARAMETERS

            CREATE procedure dbo.USP_REPORT_PROSPECTASSIGNMENTPROCESS_PARAMETERS
            (
                @BUSINESSPROCESSSTATUSID uniqueidentifier
            )
            as
            begin
                declare @STARTEDON datetime, @PARAMETERSETID uniqueidentifier;
                select 
                    @STARTEDON = STARTEDON,
                    @PARAMETERSETID = BUSINESSPROCESSPARAMETERSETID
                from dbo.BUSINESSPROCESSSTATUS
                where ID = @BUSINESSPROCESSSTATUSID;

                declare @NAME nvarchar(100);
                select @NAME = NAME
                from dbo.PROSPECTASSIGNMENTPROCESS
                where ID = @PARAMETERSETID;

                declare @TABLENAME nvarchar(256);
                select @TABLENAME = TABLENAME from dbo.BUSINESSPROCESSOUTPUT
                where BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID and upper(TABLEKEY) = 'PARAMETERS';

                declare @SQLTOEXEC nvarchar(max);
                set @SQLTOEXEC = '    select top 1
                                        @NAME as NAME, 
                                        PARAMETERS.PROCESSTYPECODE,
                                        -- Prefer to use the record''s current value in case the name changed

                                        -- but use the cached name in case the record doesn'' exist anymore

                                        coalesce(IDSETREGISTER.NAME, PARAMETERS.PROSPECTSELECTIONNAME) as PROSPECTSELECTIONNAME, 
                                        coalesce(SOURCEMANAGER.NAME, PARAMETERS.SOURCEMANAGERNAME) as SOURCEMANAGERNAME, 
                                        coalesce(DESTINATIONMANAGER.NAME, PARAMETERS.DESTINATIONMANAGERNAME) as DESTINATIONMANAGERNAME,
                                        PARAMETERS.INCLUDEPROSPECTMANAGERS, 
                                        PARAMETERS.INCLUDEPRIMARYMANAGERS, 
                                        PARAMETERS.INCLUDESECONDARYMANAGERS, 
                                        PARAMETERS.INCLUDESECONDARYSOLICITORS, 
                                        PARAMETERS.INCLUDESTEPSANDINTERACTIONS,
                                        @STARTEDON as STARTEDON
                                    from dbo.' + @TABLENAME + ' as PARAMETERS
                                    left join dbo.IDSETREGISTER on IDSETREGISTER.ID = PARAMETERS.PROSPECTSELECTIONID
                                    left join dbo.CONSTITUENT as SOURCEMANAGER on SOURCEMANAGER.ID = PARAMETERS.SOURCEMANAGERID
                                    left join dbo.CONSTITUENT as DESTINATIONMANAGER on DESTINATIONMANAGER.ID = PARAMETERS.DESTINATIONMANAGERID'

                exec sp_executesql @SQLTOEXEC,N'@STARTEDON datetime,@NAME nvarchar(100)',@STARTEDON=@STARTEDON,@NAME=@NAME;
            end