USP_PDACCOUNTCODEMAPOFFICE_UPDATEENTRY

Adds/updates a system-defined entry in the PDACCOUNTCODEMAPOFFICE table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@OFFICEID	int	IN
@TSLONG	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_PDACCOUNTCODEMAPOFFICE_UPDATEENTRY(
    @ID uniqueidentifier,
    @NAME nvarchar(100),
    @OFFICEID int=0,
    @TSLONG int=0,            
    @CHANGEAGENTID uniqueidentifier = NULL            
)
as
begin

declare @CHANGEDATE datetime;

exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CHANGEDATE = getdate();        

if (select count(ID) from dbo.PDACCOUNTCODEMAPOFFICE where ID = @ID) = 0
    insert into dbo.PDACCOUNTCODEMAPOFFICE(ID, NAME, OFFICEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID,@NAME,@OFFICEID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
else
    update dbo.PDACCOUNTCODEMAPOFFICE
        set NAME = @NAME,
            OFFICEID = @OFFICEID, 
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end