I am not saying that CTEs are bad, just if you are to use a CTE created in the query more than once, the query will be executed multiple times....

I think anyone who wants to use CTEs should read this article http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/17/non-recursive-common-table-expressions-performance-sucks-1-cte-self-join-cte-sub-query-inline-expansion.aspx.

I have a coworker who wrote a CTE that has 10 different queries and a few...

I find it strange that in today's day and age individual logins are being created. We used to do it ourselves, when we were in Sybase.

The easiest way to...