Doesn't the or in the end kill any change of an index seek?

Because of decimal (x,2), you lose the last digit from the value. Then the convert to int kills the rest of the decimals, this is not what is asked...

I had never thaught of that for you Loner... but it's an awesome idea. You should definitly go on as a freelancer. It may not always be as...

You can always submit your own questions... your contribution would certainly be very appreciated.

You need to buy it. Click my link and go to Amazon to get it.

I wonder if that behavior could change depending on the SET CONCAT_NULL_YIELDS_NULL setting!?!?.

Still pretty damn annoying to have to put up with that cr*p :w00t:.

Books online (bol for short) has all the info you need. The thing is that you need to know what you're looking for in order to find it in...

What error does that throw?.. I'm guessing something like object not found, but I'm sure it would take me a few minutes to figure out what was happening!

I'd strongly advise to go with my asynchronous solution. That way access would only be used as a starting trigger, nothing more. Timeouts could never be an issue.

Also...

Why in heavens name would you say something like that?? :hehe:.

Ya I want to see this too!

I just want to point out that my solution was provided with the idea that leading and trailing 0 had to be trimmed. I'm curious to see what you...

Oh believe you me, they are worth it ;).

Imagine a db with 100 000 transactions per MONTH

Users have write access to all the tables... and you need to cover your but because there are not all that techno...

You should send those in for the QOTD.

Can't wait to see the stats on those questions.