USP_BATCHCONSTITUENTUPDATE_UNDELETE

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy




    create procedure dbo.USP_BATCHCONSTITUENTUPDATE_UNDELETE
       (
              @ID int,
        @CHANGEAGENTID uniqueidentifier
       ) as

    set nocount on;

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    --Reset Transactions.BeginDownload to NULL if user (is deleted &) undeleted

    IF EXISTS (SELECT    * FROM    ClientUsers C    JOIN    Transactions T ON C.ID= T.BBNCUserID WHERE    T.BBNCUserID= @ID)
    BEGIN    
      UPDATE  Transactions SET BeginDownload= NULL, EndDownload= NULL WHERE BBNCUserID= @ID      
    END

    RETURN 0;