Wow, lots of discussion on the whys and wherefores here guys. Nice to have the big guns discussing the optimal solution to my question! 🙂

Got to say though, the solution...

Guys, sorry for the late reply (been out of office). Have just checked out the code Paul posted and it works like a dream! I now just need to get...

Hi Chris

The bummer is it's a different date range each time! Ideally I'd like whatever code I use to get the date range in question first, i.e. find the min...

Dave - Fair point, but there's a bit of (dull) background as to why I'm looking down other paths...

As it happens we do it in SSRS at the moment,...

Realising my initial post may have been a little verbose, I'm going to rephrase it for those short on time...!

Anyone know of any way you can set a global parameter...

Would be good to know what are the advantages of this approach?

Thanks

Nick