USP_BATCHTEMPLATE_SETDEFAULTSFORCUSTOM

CREATE procedure dbo.USP_BATCHTEMPLATE_SETDEFAULTSFORCUSTOM
@ID uniqueidentifier output,
@ORIGINALID uniqueidentifier 
as
begin

declare @CHANGEAGENTID uniqueidentifier;

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

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

    update N set
    BATCHNUMBERINGSCHEMEID = O.BATCHNUMBERINGSCHEMEID
  , DEFAULTVALIDATEBEFORECOMMIT = O.DEFAULTVALIDATEBEFORECOMMIT
  , DEFAULTCHECKFORDUPLICATES = O.DEFAULTCHECKFORDUPLICATES
  , DEFAULTDELETEBATCHAFTERCOMMIT = O.DEFAULTDELETEBATCHAFTERCOMMIT
  , DEFAULTCREATEEXCEPTIONBATCH = O.DEFAULTCREATEEXCEPTIONBATCH
  , DEFAULTCREATECONTROLREPORT = O.DEFAULTCREATECONTROLREPORT
  , DEFAULTCREATEOUTPUTSELECTION = O.DEFAULTCREATEOUTPUTSELECTION
  , AUTOSAVEONROWCHANGE = O.AUTOSAVEONROWCHANGE
  , IMPORTONLY = O.IMPORTONLY
  , CHANGEDBYID = @CHANGEAGENTID
  , DATECHANGED = @CURRENTDATE
FROM BATCHTEMPLATE as N JOIN BATCHTEMPLATE as O
on O.ID = @ORIGINALID
and N.ID = @ID

end