Another workaround could be joining with Calendar table so that it can use dynamic partition elimination.
Sandipan
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2008 Indexes