USP_RESEARCHGROUP_SETISREFRESHING

create procedure dbo.USP_RESEARCHGROUP_SETISREFRESHING (
    @RESEARCHGROUPID uniqueidentifier,
  @ISREFRESHING bit,
    @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

    update dbo.RESEARCHGROUP
    set ISREFRESHING = @ISREFRESHING,
    LASTREFRESH = case when @ISREFRESHING = 0 then @CURRENTDATE else LASTREFRESH end,
    DATECHANGED = @CURRENTDATE,
    CHANGEDBYID = @CHANGEAGENTID
  where ID = @RESEARCHGROUPID;