Viewing 2 posts - 1 through 2 (of 2 total)
It seems to me that I found the solution:
DECLARE @XML XML
DECLARE @ElementName VARCHAR(20)
SET @ElementName = 'city'
SELECT @XML = '
<employees>
<employee>
<name>Jacob</name>
<city>NY</city>
...
March 4, 2010 at 5:34 am
#1128415
<team>SQL Server</team>
</employee>
March 4, 2010 at 5:16 am
#1128410