USP_FILES_BULKSETDESCRIPTION

create procedure dbo.USP_FILES_BULKSETDESCRIPTION
(
    @XML xml    
)
as
begin
    set nocount on

    update dbo.DOCUPLOADFILES
    set    [DESCRIPTION] = F.[DESCRIPTION]
    from dbo.DOCUPLOADFILES DUF
    inner join (select DOCFILES.DOCFILE.value('id[1]', 'int') as ID, DOCFILES.DOCFILE.value('description[1]', 'nvarchar(1024)') as DESCRIPTION from @XML.nodes('/docfiles/docfile') DOCFILES(DOCFILE)) F on F.ID = DUF.ID

end