The following code shows you how to create an element and insert the dynamic data into the element's definition:Dim customerData As XElement = Print the XML data to a document.

Even better, these examples show how to pass XML data to stored procedures, and how they can be made to read single or multiple sets of criteria easily, using only a few lines of TSQL.