USP_FILE_BULKPUTINTRASHBIN

create procedure dbo.USP_FILE_BULKPUTINTRASHBIN(@XML xml)
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)

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