There are a huge number of possibilities as to what is wrong.  At this point, I'm going to suggest that we might not be able to help at all without...

Thanks for the feedback on my comment.

Shifting gears a bit, I've found that partitioned tables are pretty annoying compared to partitioned views.  I can do everything I can...

This is a nicely written article.  Just as a suggestion for future articles, it would have been great if you identified where you got the Sales and SaleItems data from or...

Nicely documented, Jason.  You should write articles.

Tim,
I don't know about anyone else but that came out looking like a very strange language.  Not sure what font you uses but there's a one to one character...