Tag Archives: ctes

  1. You can’t DELETE TOP (x) with an ORDER BY


    September 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

  2. Updateable CTEs


    October 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

  3. What is a CTE


    April 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

  4. CTEs beyond SELECT


    November 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013