USP_FUZZYDATE_UPDATEENTRY

This adds/updates a system-defined entry in the FUZZYDATE table.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DATETYPECODE	tinyint	IN
@SEQUENCE	tinyint	IN
@TSLONG	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_FUZZYDATE_UPDATEENTRY(
    @ID uniqueidentifier,
    @NAME nvarchar(100),
    @DATETYPECODE tinyint= null,
    @SEQUENCE tinyint=null,
    @TSLONG int=0,            
    @CHANGEAGENTID uniqueidentifier = NULL
)
as
begin

declare @CHANGEDATE datetime;

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

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

return 0
end