USP_FILE_BULKDELETE

create procedure dbo.USP_FILE_BULKDELETE(@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)

    delete dbo.DOCUPLOADFILES from dbo.DOCUPLOADFILES inner join @FILEIDS F on DOCUPLOADFILES.id = F.FILEID

end