DECLARE @t TABLE (id int, data XML)
INSERT INTO @t(id, data) SELECT 1, '
<Employees>
  <Employee name="Jacob" city="NY" Team="SQL Server"/>
  <Employee name="Steve" city="FL" Team="SQL Server"/>
  <Employee name="Bob" city = "CA" Team="ASP.NET"/>
</Employees>'

INSERT INTO @t(id, data) SELECT 2, '
<Employees>
  <Employee name="Jacob" city="NY" Team="SQL Server"/>
  <Employee name="Steve" city="FL" Team="SQL Server"/>
  <Employee name="Bob" city = "CA" Team="ASP.NET"/>
</Employees>'

UPDATE @t
SET data.modify('
    delete (Employees/Employee[@Team="SQL Server"]/@city)
    ')
SELECT * FROM @t 

CREATE TABLE Table1 (
  ID INT
  ,XML1 XML
  ,XML2 XML )

   <Response>
      <Value>Idaho</Value>
      <Result>ID</Result>
      <Return>50</Return>
    </Response>

   <Response>
      <Value>Texas</Value>
      <Result>TX</Result>
      <Return>50</Return>
    </Response>

   <Response>
      <Value>Texas</Value>
      <Result>TX</Result>
      <Return>50</Return>
    </Response>
   <Response>
      <Value>Texas</Value>
      <Result>TX</Result>
      <Return>50</Return>
    </Response>

SELECT (
	SELECT XML1, XML2
	FROM table1 
	FOR XML PATH(''), TYPE
).query('/*/Response')
/*
<Response>
  <Value>Idaho</Value>
  <Result>ID</Result>
  <Return>50</Return>
</Response>
<Response>
  <Value>Texas</Value>
  <Result>TX</Result>
  <Return>50</Return>
</Response>
*/