title: Equivalent to WITH clause in Sybase ASE
body: <p>It appears that WITH is supported only in <strong>Sybase SQL Anywhere</strong>:
  <a href="http://dcx.sybase.com/1100/en/dbusage_en11/commontblexpr-s-5414852.html" rel="nofollow noreferrer">http://dcx.sybase.com/1100/en/dbusage_en11/commontblexpr-s-5414852.html</a></p>
  
  <p>...but <strong>not in Sybase ASE</strong> :(</p>
  
  <p>Can someone suggest if there is a equivalent construct in Sybase ASE? There are other ways to implement stuff instead of using WITH, but we are planning to repurpose some of our dynamically generated SQLs to run in Sybase and support for WITH or something close to that syntax is very much desired.</p>