Thanks for the info  Ninja's_RGR'us

I believe you are correct that it is a datetime limit - thus it works in other databases (and instances).

I understand @@dbts returns a timestamp.  Up until today, I could run the statement (and I can still run it on a couple other SS2000 instances on other machines).

Further investigation...

Hi

I'd suggest building a subquery for table 2

such as: Select  from table2 where comments <> 'completed'

then use that instead of table 2.

Initial response to this tends to be - can't...