title: why can't I access my CTE after I used it once?
body: <p>My stored procedure looks like:</p>
  
  <pre><code>WITH MYCTE(....)
  AS 
  (
  ...
  )
  
  UPDATE ... (using my CTE)
  
  
  
  DELETE ( using my CTE)  &lt;---  says the object, my CTE, doesn't exist
  </code></pre>
  
  <p>Can I only use it once?</p>