title: Order By Month Name in Sql-Server
body: <p>I have Below Table named session </p>
  
  <pre><code>SessionID   SessionName
  
  100         August
  101         September
  102         October
  103         November
  104         December
  105         January
  106         May
  107         June
  108         July
  </code></pre>
  
  <p>I executed the following query I got the output as below.</p>
  
  <pre><code>Select SessionID, SessionName 
  From dbo.Session  
  
  SessionID   SessionName
  100         August
  101         September
  102         October
  103         November
  104         December
  105         January
  106         May
  107         June
  108         July
  </code></pre>
  
  <p>the results get ordered by Session ID. But I need the output as below,</p>
  
  <pre><code>SessionID   SessionName 
  106         May
  107         June
  108         July
  100         August
  101         September
  102         October
  103         November
  104         December
  105         January
  </code></pre>
  
  <p>How to achieve this in sql-server? thanks for the help</p>