USP_FILES_BULKUPDATE

          CREATE procedure dbo.USP_FILES_BULKUPDATE
          (
              @XML xml    
          )
          as
          begin
              set nocount on

              update dbo.DOCUPLOADFILES
              set    [DESCRIPTION] = F.[DESCRIPTION], [Url] = F.[URL], [Name] = F.[Name], [APPROVED] = F.[APPROVED], [FOLDERID] = F.[FolderId]
              from dbo.DOCUPLOADFILES DUF
              inner join (select DOCFILES.DOCFILE.value('id[1]', 'int') as ID, 
                              DOCFILES.DOCFILE.value('description[1]', 'nvarchar(1024)') as DESCRIPTION,
                              DOCFILES.DOCFILE.value('url[1]', 'nvarchar(1024)') as URL,
                    DOCFILES.DOCFILE.value('name[1]', 'nvarchar(1024)') as NAME,
                    DOCFILES.DOCFILE.value('folderid[1]', 'int') As FOLDERID,
                    DOCFILES.DOCFILE.value('approved[1]', 'bit') as APPROVED
                              from @XML.nodes('/docfiles/docfile') DOCFILES(DOCFILE)) F on F.ID = DUF.ID
          end