var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: with clluse vs temp table
hi there fellow SQL Devs/Admins i have a question. is there a significant difference of using the WITH statement rather than a Temp Table besides less typing. l
Yes. WITH is a shorthand for a subquery. It is part of a query and does not have to write to a disk. It is also portable; the T-SQL temp table model is not ANSI! It is 1970's sybase/UNIX.
In higher SQL products, the optimizers will decide to materialize the CTE and to share it among sessions. They can also do this with temp tables, but they are required to do it no matter what.