t-sql XML parse out to multiple records with event and data and value

[Aniguidge]

I'm trying to parse this out. I want one record for each event, so I need a way to query each event separately. But I'd like it to look something like this:\[code\]Event Name || ID || Timestamp || process_utilization---------------------------------------------------------------------------------------------scheduler_monitor_system_heal_ring_buffer_recorded || 0 || 0 || 33Here's the XML:<events> <session startTime="2012-09-06T10:48:15.373" droppedEvents="0" largestDroppedEvent="0"> <RingBufferTarget truncated="0" processingTime="0" totalEventsProcessed="14" eventCount="14" droppedCount="0" memoryUsed="3994"> <event name="scheduler_monitor_system_health_ring_buffer_recorded" package="sqlos" timestamp="2012-09-19T16:46:33.091Z"> <data name="id"> <type name="uint32" package="package0" /> <value>0</value> </data> <data name="timestamp"> <type name="uint64" package="package0" /> <value>0</value> </data> <data name="process_utilization"> <type name="uint32" package="package0" /> <value>33</value> </data> </event> <event name="resource_monitor_ring_buffer_recorded" package="sqlos" timestamp="2012-09-19T16:46:38.386Z"> <data name="id"> <type name="uint32" package="package0" /> <value>0</value> </data> </event> </RingBufferTarget> </session></events>\[/code\]