USP_RESEARCHGROUP_UPDATELASTACCESSED

create procedure dbo.USP_RESEARCHGROUP_UPDATELASTACCESSED (
    @RESEARCHGROUPID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier = null,
  @CHANGEAGENTID uniqueidentifier = null
) as
    set nocount on;

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

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

  declare @ID uniqueidentifier;
  select @ID=ID 
  from RESEARCHGROUPLASTVISITED
  where @CURRENTAPPUSERID = APPUSERID 
      and @RESEARCHGROUPID = RESEARCHGROUPID;

  if @ID is not null
  begin
      update RESEARCHGROUPLASTVISITED
      set DATEACCESSED = @CURRENTDATE
      where @ID = ID
  end else begin
      insert into dbo.RESEARCHGROUPLASTVISITED
      (APPUSERID,RESEARCHGROUPID,DATEACCESSED,ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
      values
      (@CURRENTAPPUSERID,@RESEARCHGROUPID,@CURRENTDATE,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE)
  end