急！存储过程中分解XML参数的方法

<root>
  <SaleMan>
  <SaleManId>1</SaleManId>
  <SaleManCode>001</SaleManCode>
  <Nodes>
  <Node>
  <NodeId>101</NodeId>
  <NodeCode>D101</NodeCode>
  <CardSetting>
  <R1>1</R1>
  <R2>2</R2>
  <R3>3</R3>
  </CardSetting>
  </Node>
  <Node>
  <NodeId>101</NodeId>
  <NodeCode>101</NodeCode>
  <CardSetting>
  <R1>1</R1>
  <R2>2</R2>
  <r3>3</r3>
  <R8>0</R8>
  </CardSetting>
  </Node>
  <Node>
  <NodeId>101</NodeId>
  <NodeCode>101</NodeCode>
  <CardSetting>
  <R1>1</R1>
  <R2>2</R2>
  <r3>3</r3>
  </CardSetting>
  </Node>
  </Nodes>
  </SaleMan>

  <SaleMan>
  <SaleManId>1</S