USP_SEARCHCONSTITUENT_BATCHCONSTITUENTUPDATE

CREATE procedure dbo.USP_SEARCHCONSTITUENT_BATCHCONSTITUENTUPDATE
(
    @BATCHID uniqueidentifier
)
as
begin
    set nocount on;

    begin try

        if object_id('tempdb..#SEARCHCONSTITUENTUPDATE') is not null
        drop table #SEARCHCONSTITUENTUPDATE;

        create table #SEARCHCONSTITUENTUPDATE ([CONSTITID] uniqueidentifier);

        insert into #SEARCHCONSTITUENTUPDATE
        select
        distinct [PRIMARYRECORDID]
        from
        dbo.[BATCHCONSTITUENTUPDATE]
        where
        [BATCHID] = @BATCHID and
        [PRIMARYRECORDID] is not null;

        create index [IX_SEARCHCONSTITUENTUPDATE_CONSTITID] on #SEARCHCONSTITUENTUPDATE(CONSTITID);

        exec dbo.[USP_POPULATESEARCHCONSTITUENT_FROMTABLE] '#SEARCHCONSTITUENTUPDATE', 'CONSTITID';

        if object_id('tempdb..#SEARCHCONSTITUENTUPDATE') is not null
        drop table #SEARCHCONSTITUENTUPDATE;

    end try
    begin catch
        exec dbo.[USP_RAISE_ERROR];
        return 1;
    end catch

    return 0;
end