SQL Server中的表的分层XML

I'm trying to convert data streaming from a medical device into a usable table. The device spits out XML-formatted text via an RS-232 port, which I've captured using a software called ComCap4 from Magenta Systems. I've been able to convert the one row per line of text into an XML object, but am getting turned around by the XML syntax in SQL Server.I'm trying to convert data streaming from a med