UFN_FILES_URLSINUSE

      CREATE function dbo.UFN_FILES_URLSINUSE
      (
      @URLS xml,
      @CLIENTSITESID int
      )
      returns table
      as 
      return
      (
          select F.URL, F.ID
          from @URLS.nodes('/URLS/U') URL(U)
          inner join dbo.DocUploadFiles F on F.URL = URL.U.value('.', 'nvarchar(255)') 
          where F.ClientSitesID = @CLIENTSITESID
      )