Home Forums SQL Server 2008 T-SQL (SS2K8) Multiple UNION ALL queries cause SSMS to hang/freeze up/ slow down? RE: Multiple UNION ALL queries cause SSMS to hang/freeze up/ slow down?

  • February 11, 2011 at 3:37 pm

    #1285938

    In this case CTE1 is

    just a month/quarter table.

    Quarter | Month

    1 |1

    1|2

    1|3

    2|4

    2|5

    ...

    4|10

    4|11

    4|12

    then the other CTEs are just used later to join against that.

    Though I suppose I could just create a quarter month table to use.