Strange.

Last week my queries weren't working but this week they are. As far as I can tell there have been no changes in the environments.

What would cause the error...

Yes, I have tried declaring a variable of DATE type to match the SQL Server table field type, but this did not fix the problem.

Hi Shafat,

Yes, I have tried OPENQUERY and it does not fix the problem. The sub query that contains the statement works fine but when it is joined to the...

Sad event but I agree with Hall of Fame that your response was unprofessional.

Thanks Chris. This solves the problem.