USP_FILE_BULKMOVE

create procedure dbo.USP_FILE_BULKMOVE
(
@XML xml,
@FOLDERID int
)
as
begin
    set nocount on

    declare @FILEIDS table ([FILEID] int)
    insert into @FILEIDS select IDS.ID.value('.', 'int') from @XML.nodes('/FILE/id') IDS(ID)

    if @FOLDERID <= 0
        set @FOLDERID = null

    update dbo.DOCUPLOADFILES
    set FOLDERID = @FOLDERID
    from dbo.DOCUPLOADFILES DUF
    inner join @FILEIDS F on F.FILEID = DUF.ID
end