Hi,

Vladan, that works perfectly. Thanks very much for this. I wish you could see the mess this table is in. It not only holds this type of bonus but incremental...

Hi,

:blush:

So many replies so quick.

I've modified Lowell's statement to generate the data in a table

thanks for the pointer i'll remeber to do that next time.

Create Table BONUS_TEMP (Account varchar(30),...

Hi,

Thanks for the reply.

I found an application called Microsoft Office Document Imaging which seems to be a virtual printer type affair. It created files with an mdi extension and that has done...

Hi,

As a matter of interest what is the interface for this database and is this database involved in any form of replication?

K.

Hi,

http://jooto.com/blog/index.php/2005/11/01/the-myth-of-data-integrity/

Only read if you don't mind having nightmares

k.

In for penny...

Your VB comment is telling because it assumes that complexity is restriction enough i.e. if it's too complex to understand then no-one who isn't competent can use it. All...

Hi

If you mean as an OLTP database then yes i would agree that it's not the best choice - not even in the list choices, and i would question anyone’s judgment if that...

Hi,

Sorry, but blaming Access for poorly developed apps is utter nonsense, it's the same criticism leveled at VB by programming snobs the world over. I've seen **** written in a...

Hi,

I applied for my current role through an advert placed by a recruitment agency. I got to know the owner of the company as he dealt with the position himself...

Hi,

I am not personally adverse to risk taking having changed career twice so far and setting myself up for a third move I think I have taken more than my...

 [Quote P Jones]Very appropriate having recently been slated for using SSRS2005 and pushing it instead of Crystal Reports 8 because CR8 wouldn't do the job and give the...

The interesting point that is raised here is one of risk perception.

The examples you site as having managed the risk/reward situation successfully are examples because they were successful or...

Hi,

I live just down the road from Cambridge and i hate driving around it. Cambridge is very anti-car with many areas now inaccessible due to automatic road barriers, the council...

I suppose as usual it's one of those questions which is designed to test how well you deal with a question you don't know the answer too. Occasionally they back-fire...

An interesting debate.

I was recently looking at some of the features in SS 2008 and came across the Declaritve Management Function which -as far as i can tell - allows...