USP_REPORT_AMPROIMPORTBATCHCONTROL_CONSTITUENT

            CREATE procedure dbo.USP_REPORT_AMPROIMPORTBATCHCONTROL_CONSTITUENT
            (
                @BATCHID uniqueidentifier
            )
            with execute as owner
            as
            begin
                set nocount on;

                declare @TABLENAME nvarchar(128);
                select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 0);

                declare @SQL nvarchar(max);
                set @SQL = N'set nocount on;' +
                                ' select' +
                                    ' REPORTTABLE.ID,' +
                                    ' REPORTTABLE.CONSTITUENTNAME,' +
                                    ' case' +
                                        ' when BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_LINKID is null then 1' +
                                        ' else 0' +
                                    ' end ISNEWCONSTITUENT,' +
                                    ' REPORTTABLE.ISINDIVIDUAL,' +
                                    ' dbo.UDA_BUILDLIST(BATCHAMPROIMPORTMESSAGE.MESSAGE) MESSAGES,' +
                                    ' BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_AUTOMATCHSTATUSCODE AUTOMATCHSTATUSCODE' +
                                ' from ' +
                                    ' dbo.' + @TABLENAME + ' REPORTTABLE' +
                                    ' inner join dbo.BATCHAMPROIMPORT on BATCHAMPROIMPORT.ID = REPORTTABLE.BATCHRECORDID' +
                                    ' inner join dbo.BATCHAMPROIMPORTCONSTITUENT on BATCHAMPROIMPORTCONSTITUENT.ID = BATCHAMPROIMPORT.ID' +
                                    ' left join dbo.BATCHAMPROIMPORTMESSAGE on BATCHAMPROIMPORTMESSAGE.AMPROIMPORTID = REPORTTABLE.BATCHRECORDID' +
                                ' where BATCHAMPROIMPORT.RECORDTYPECODE = 2' +
                                ' group by' +
                                    ' REPORTTABLE.ID,' +
                                    ' REPORTTABLE.CONSTITUENTNAME,' +
                                    ' BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_LINKID,' +
                                    ' REPORTTABLE.ISINDIVIDUAL,' +
                                    ' BATCHAMPROIMPORTCONSTITUENT.CONSTITUENT_AUTOMATCHSTATUSCODE,' +
                                    ' BATCHAMPROIMPORT.SEQUENCE' +
                                ' order by BATCHAMPROIMPORT.SEQUENCE;'

                exec sp_executesql @SQL;
            end