Bonus Prize to Hugo !

That is a brilliant consideration, and one that in theory I should spend a lot more time researching.

I have to admit, I know little about...

Thanks for the extra clarification Ed, appreciated !

🙂

Thanks Ed, that's put some lovely 'exact' detail on the inner workings ... something I unfortunately only have a fuzzy knowledge of.

You have inspired me to go do much more...

Brilliant guys, thank you.

Solution was to pass the variable to a 2nd procedure where it is accepeted as a parameter.

As expected, I no longer get the short execution time as...

I see where you are coming from now.

You just want to have an off-the-shelf front end, point it at your database, and hey presto !

All I can say is "Good...

Still a little confused on your current situation,

but if I ignore your context, I can outline some options.

Moving up from simply 'spreadsheets', most people start with an Access Database...

Ben,

The 'bumble' might help but I can't find it.

When you say 'better' .. what exactly do you mean ?

There are infinite ways to interact with SQL Server and each solution...

So simple, am kicking myself !

Many thanks for that, and the included link.

🙂

oooh, bad news for me then 🙁

But thanks, at least now I know that I'm not missing some simple solution.

I'm thinking that the DB engine must have this logic 'under...

Thanks for the book reccommends folks, I'll take a look at both.

I'm with the theory of storing all currencies, but I'm going to have +/- 100 measures that will need...

Thanks for that Roy, it puts some sense to it.

Yes, I have installed VS 2008; VS 2010 C# Express & VWD Express.

The (local) version I seem to have full...