GenerationGaming
New Member
I have some XML data stored in a varchar(max) column on SQL Server 2005. The data is in the form (FQTN = fully qualified type name):\[code\]<?xml version="1.0" encoding="utf-16"?><History xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <EntityViews> <EntityProxy Type="FQTN" Key="386876" /> <EntityProxy Type="FQTN" Key="387981" /> <!-- etc. --> </EntityViews></History>\[/code\]How can I select Type, Key so that I get a tabular result from the XML data in this column for a single row? The table has an identity primary key named HistoryId.