Tag Archives: ctes
-
You can’t DELETE TOP (x) with an ORDER BY
8September 19, 2018 by Kenneth Fisher
Did you know you can’t do this? Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword …
Continue reading -
Updateable CTEs
5October 18, 2017 by Kenneth Fisher
CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t …
Continue reading -
What is a CTE
3April 6, 2015 by Kenneth Fisher
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. …
Continue reading -
CTEs beyond SELECT
5November 20, 2012 by Kenneth Fisher
The other day I was writing a query to pull some DMV information and I ended up using several CTEs …
Continue reading
SQL Studies 