DaveDB (1/7/2014)
Hi Phil,Thanks for the tip. Didn't even notice the apostrophes 🙂
No problem. My colleagues love the fact that I'm an amateur proofreader as well as a SQL Server professional:w00t:
And if you need any assistance with your calendar table, please post back - though there are numerous resources out there already to get you going. I'd set the new Calendar column to be Tinyint Not Null and set its value to 0 (no holiday) or 1 (holiday).
(Tinyints can be easier than bits when it comes to sums and counts.)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.