Post reply

When to use Derived Tables and when to use CTEs?

  • May 9, 2013 at 6:55 am

    #293186

    I'm almost finished with the "2012 T-SQL Fundamentals" book and while I understand both derived tables and CTEs, I'm having trouble to understand when to use which query? In fact, I think the most common problem for those starting a new career in SQL is when to use which type of search query? There are millions and each problem could have 20 different types of queries.

  • May 9, 2013 at 9:27 am

    #1613858

    http://www.sqlservercentral.com/Forums/Topic599611-149-3.aspx#bm602471

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • May 9, 2013 at 9:29 am

    #1613860

    Thank you. Next time I'll try and search the topics before creating one that's already been done.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply