Basic XML Examples in SQL Server
Select values from an XML column id FooID FooText 1 34 some text 2 56 some text Select from XML using a variable id ValueByVariable 1 22 2 14 Use value from query results as part of query id ValueByColumn 1 34 2 93 Select from a table into XML