title: How to show one column in two column base on second column in SQL Server
body: <p>I have a table <code>sales</code> with columns</p>
  
  <pre><code>Month   SalesAmount
  --------------------------
  4   50000
  5   60000
  6   70000
  7   50000
  8   60000
  9   40000
  </code></pre>
  
  <p>I want result like this </p>
  
  <pre><code>From Month  To Month    Result 
  -----------------------------------------------
  4                  6    Increasing
  6                  7    Decreasing
  7                  8    Increasing
  8                  9    Decreasing
  </code></pre>
  
  <p>without using a cursor </p>