A simple way to SELECT XML string in a tabular format by using Nodes and OPENXML(). Output as XML String:
sqlwithmanoj.com