J Hines (8/25/2011)
This is EXACTLY what I am trying to do, only by month rather than week. Did you ever get help with this?
1) Please don't post a "me too" to a 2 year old thread - start a new one.
2) Partitioning is a VERY advanced topic where you can get yourself into trouble (and even make things much worse) if you don't know what you are doing. PLEASE do yourself a favor and get some professional help for a little bit to make sure you know what you really need to do and how to properly implement/test/maintain it.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service