title: How does the "With" keyword work in SQL?
body: <p>So many times seen <code>with</code> and, so many times SQL Server ask that with has <code>;</code> before it </p>
  
  <p>How does <code>;with ...</code> work?? </p>
  
  <pre><code>;with coords(...) as (
  SELECT * ...
  )
  </code></pre>
  
  <p>Why must have <code>;</code> before it?</p>