Thanks very much - we had it installed on the Standard SQL Server, will try and get it moved across to Enterprise.

Cheers,

Andrew.

The Dixie Flatline (9/8/2016)

---

Steven and Andrew: Obviously I didn't invent the calendar table, this article was just to reintroduce it. There can be many variations on the...

Nice approach. I've achieved similar adapting code by Dusty. I've added in a truckload of columns, including many offsets which are particularly useful for automatically setting prompts in reporting. It...