Thanks, Adi, I'll fix that tomorrow.

Schalk

Auckland, New Zealand

Thanks, everybody, for your suggestions.

I want to have a setting on the server, saved in a table, which can be modified by a system administrator.

Because our system uses triggers to...

Hi Prasad

Yes, you guesses right, it was within Query Analyser, and your suggestion was spot-on. 

Thanks

Schalk

I agree with Olav. I have also found the least problems with dates in the format YYYYMMDD. So your code could be WHERE DateOfInterest BETWEEN '20041001' AND '20050930'.

Beware,...

Hi Vik

Yes, I have used Advantage to turn a Clipper system into a real client/server system back when we were doing our Y2k modifications. It was a million times...

You could also do a left outer join, and see whether any records are returned. If none are returned, it means that all the records from table A are in...

Jeff

I don't know whether this is just due to a setting on our server, but the run_duration values don't have a fixed length. Some are 11638, while others are...

Hi

I agree with Wayne and Edwin. It might be a matter of taste, but it just looks neater (and better planned) to go the route of

if exists()

update

else

...

Hi Kevin

As I understand it, a constraint has to do with inputting data into the table. If the constraint is unique, you would not be able to insert a record...

Hi Dan

You can try using a recursive UDF. You will pass to it the last car's name, as well as the string of already-concatenated names. I have tried it with...