title: Reorder nodes in SQL Hierarchy data type
body: <p>Using Hierarchy data type on SQL 2008. Nodes in my hierarchy go like this:</p>
  
  <pre><code>value   node 
  36    /8/1/
  38    /8/2/
  34    /8/3/
  40    /8/4/
  42    /8/5/
  44    /8/6/
  46    /8/7/
  48    /8/8/
  </code></pre>
  
  <p>I'd like to rearrange nodes so that /8/3/ and /8/1/ switch places. Any idea on how to do this?</p>
  
  <p>Only idea that I have so far is that I load all nodes on a level in Array, order them the way I want them to be, delete them from table and insert in sorted form.</p>