• Take a look at the following link on how to create, use and manage partitioned views:

    http://technet.microsoft.com/en-us/library/ms190019(v=sql.105).aspx



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]