title: TSQL Order By Specific Value
body: <p>I need to order my results such that all items with the status column being a specific value come up first, then by date.</p>
  
  <p>I tried this:</p>
  
  <pre><code>SELECT Id, Status, CreatedAt FROM Table
  ORDER BY (Status=1) DESC, CreatedAt
  </code></pre>
  
  <p>I figured I'd get a bool value on (Status=1) so ordering by DESC to put the true (1) values on the top.</p>
  
  <p>But I'm getting a syntax error.  Is this possible and if so what is the correct syntax?</p>
  
  <p>Thanks!</p>