USP_FILES_BULKAPPROVE

CREATE procedure dbo.USP_FILES_BULKAPPROVE
(
    @XML xml,
    @NUMBERAPPROVED int = 0 output
)
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)

    set @NUMBERAPPROVED = (select count(1)
    from dbo.DOCUPLOADFILES DUF
    inner join @FILEIDS F on F.FILEID = DUF.ID
    where DUF.APPROVED <> 1)

    update dbo.DOCUPLOADFILES
    set    [APPROVED] = 1
    from dbo.DOCUPLOADFILES DUF
    inner join @FILEIDS F on F.FILEID = DUF.ID

end