Just for the benefit of the folks talking about grabbing the count of all rows in the table separately, note that in a lot of cases we can't look at...

I like it. For the date calculations, I suggest a wrapper function that takes start date and end date, or start date and range type, and calculates the number...

Yes, it's true, not every tool will do everything you want. That is true of pretty much all software out there, whether you bought it, wrote it, bought the...

Personally, this seems like a lot of heavy lifting and manual labor, and the effort involved seems to outweigh the costs of commercial tools already available. For example, SQL...