USP_IMPORTPROCESS_SETPARAMETERS

create procedure dbo.USP_IMPORTPROCESS_SETPARAMETERS
(
  @ID uniqueidentifier,
  @TEMPFILENAME nvarchar(255),
  @CHANGEAGENTID uniqueidentifier
)
as
  set nocount on;

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

    update dbo.IMPORTPROCESS 
  set TEMPFILENAME = @TEMPFILENAME,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
    where ID=@ID;

    return 0;