Home Forums Article Discussions Article Discussions by Author Discuss content posted by Matthias Kroll Curiouse View to create for SQLServer 2005 RE: Curiouse View to create for SQLServer 2005

  • February 10, 2010 at 2:24 am

    #1116630

    matt32 (2/10/2010)

    but you can create a sp instead when you want to use cte

    ... or you can create a view without OPTION clause and add OPTION to the SELECT statement 🙂

    SELECT *

    FROM month_since_200701

    OPTION(MAXRECURSION 0)