I'm writing with a question that ostensibly relates to my work. In other words, I only want to strip out all of the attributes on my "Element" elements except for "name" and "type". This is merely to ...

I have a SQL Server 2005 table that has an XML type column. This column stores address information, and data on multiple locations can be in this column's XML.<BR><BR>Now, I need to query the ...