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 10:51 am

    #1117016

    Hi Steve,

    no problem , i haven't had the time to write a proper article on how to create a view with Option()

    at the end of the statement .. but here is the short way.

    1. Create a SP

    2. Use Eli's SP to create a View

    http://www.sqlservercentral.com/articles/T-SQL/68233/

    Sometimes it is useful to use OPTION() to kick the optimizer into the right direction 😉

    This small calendar i used for reporting sale gaps ... nothing is more difficult than reporting data that not exists :w00t:

    Regards Matthias