Yuri,

There is a way (but is risky in the sense that your app should have been designed from the ground up to handle it ) 

at begining of the connection just...

Until he notice you presidential aspirations here

Thanks god for the update button!!

Hopefully... (s)he doesn't come through this forums often

Dam! keep typing faster than me

I must admit that it was me who didn't read your post carefully 

CASE @CheckBDate WHEN = 0 THEN @NullBDate ELSE @BDate END...

Your Boss !!!

From BOL: Float and real

Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can...

>> What was the problem (so that new readers know what to try)?  <<

I think you are reading too fast ( or not ?) today 

what is the problem with joining the tables ?

Again Let me say that DROP Table and TRUNCATE Table are both minimally logged operations and neither will fill up the log!!!

Use TRUNCATE when you need to clear data ...

still no answer?

In SQL you tell the engine what you want and it determines (sometimes not so good) how to do it. To be honest this does not happens very often but...

Remi, c'mon what is the mistery ?

Chicken ?