USP_DATAFORMTEMPLATE_ADD_KPIMOVEFOLDER

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_KPIMOVEFOLDER
(
    @ID uniqueidentifier output,
    @CHANGEAGENTID uniqueidentifier = null,
    @FOLDERID uniqueidentifier = null,
    @KPIS xml = null
)
as

set nocount on;

if @ID is null
  set @ID = newid()

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

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try

        -- move KPIs
        update dbo.[KPIINSTANCE] set
            [FOLDERID] = @FOLDERID,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @CURRENTDATE
        where [ID] in
    (
      select
      T.c.value('(ID)[1]','uniqueidentifier') AS 'ID'
      from @KPIS.nodes('/KPIS/ITEM') T(c)
    )

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0