带有xml数据的存储过程。

I am trying to get the data from a field in a SQL server table. It is stored as a xml and I wanted to get each node value in a different row. The xml sample is like this:I am trying to get the data from a field in a S