It's not the country from the time zone, it's simply an 'address' table if you like - which will have country, and if applicable state. From this I'd simply like...

I guess the point is I was wondering if there was a better approach than looking up every country and every state and compiling an offset table and then using...

I think to do that I'd need to be evaluating the same condition though rather than a different field in each case. At any rate I created a public function...

Thanks Jack, I've played around with that a little bit, and experimented and it seems something like this:

=Switch(Abs(Fields!Test.Value) = 0.00, “White”,

Abs(Fields!Test.Value) <= 0.03, “Red”)

Would do it, so basically your first...

I'm just looking through your code now and trying to suss it out, many thanks for the posting.

The point in having ID in the test data (although perhaps it was...

My PC is acting as 'the server' in this situation and all of the databases are on my PC.

Via Management studio I also connect to an external SQL server...

Na, both are 2008, I installed Express about 4-5 months ago perhaps.

I right clicked on the database server (my local PC name) then properties. It said Product was MS...

To be honest in the first instance I was making sure that Developer edition would actually do what I wanted, that was the aim of the post really!

It sounds like...

Perhaps that should be clarified, we have an 'official' audit process where by we could track down the changes made to some specific entities and see a massive list of...

They'd never be used for disaster recovery, we have more up to date daily snapshots stored both on the live SQL server, on a local server here as .bak files...

Typically three uses:

1. To see how the data has changed - i.e. I might look and see table A has X rows on our live DB and Y rows on...

I wasn't aware of the snapshot side of things but I'll give it a look as I said.

As regarding the nolock situation, I'm aware it has pitfalls and I did...

Thanks for your ideas here.

I can see occasions where nolock would provide information that's incorrect, however, in our situation they would be rare and they'd be far more desirable...

Thanks, that's very helpful, I've located that value in that table and I'll discuss the options with a colleague to see what we think might be a good value here.

I'd never thought of that Daniel, that seems to do the trick perfectly, combined with a CountDistinct and I'm sorted!

Thanks!