USP_CUSTOMFORMENTRY_BULKMOVE

create procedure dbo.USP_CUSTOMFORMENTRY_BULKMOVE(@XML xml, @FOLDERID int)
as
begin

  set nocount on

  declare @CUSTOMFORMENTRYIDS table (ENTRYID int)
  insert into @CUSTOMFORMENTRYIDS select IDS.ID.value('.', 'int') from @XML.nodes('/CustomFormEntry/id') IDS(ID)

  update dbo.CUSTOMFORMENTRY set
    SITEFOLDERSID=@FOLDERID
    from dbo.CUSTOMFORMENTRY CFE
    inner join @CustomFormEntryIDs CFEI on CFEI.ENTRYID = CFE.ID    
end