USP_ADHOCQUERY_UPDATEQUERYDEFINITIONXML

create procedure [dbo].[USP_ADHOCQUERY_UPDATEQUERYDEFINITIONXML]
(
  @ID uniqueidentifier,
    @QUERYDEFINITIONXML xml,
    @CHANGEAGENTID uniqueidentifier    
)
as

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

    update dbo.[ADHOCQUERY] 
    set         
        [QUERYDEFINITIONXML] = @QUERYDEFINITIONXML, 
        [CHANGEDBYID] = @CHANGEAGENTID, 
        [DATECHANGED] = getdate()
    where ID = @ID;