I have sorted out this issue. It was a data quality problem between the UserEntered column and the LanUserId column ob the JOIN.

Thanks to all for your help.

Thanks Leon. I will give this a go and let you & all know about the outcome.

I'm not sure what you mean by "What happens when you explicitely CAST your date as DATETIMES?" The B.TimeStampEntered Column is already a DATETIME DatType. Here is a sample for...

The original post I have given is wrong. I apologise for that. But there must be some way of doing what I'm trying to do!

The query I'm trying to...

Try "Profesional SQL Server 2000 Programming" from Wrox.

Thanks Herb. I think I inderstand now. And you were correct! If I use the CONVERT(VARCHAR(10),OpenedDateTime, 101) to get the Date only, I do not need the Correlated SubQuery.

Thank you.

Herb,

That worked. I still don't understand why we have to omit the time part of the query but it worked.

If I don't perform the Correlated SubQuery, the OpenedTot Column returns...

Thanks Frank.

Thank you.

Check to see that backups to remote servers are still allowed. In other words, has anyone changed permissions to stop backups to the remote servers!

What is,

(A) The Replication model you are using?

(B) The schedule for replicating Transactions?

(C) Have you setup a profiler trace on the week ends to get more results for a...

For the past 5 years I have ,

(A) allowed Developers dbo_owner Role to their Databases and get them to create objects in the context of [dbo].[object_name].

(B) Made sa the owner...

Why don't you just use Profiler and log it to a Database?

It would be a good idea to find out just what Replication job/s are consuming 100% CPU. Either use Profiler or just do a sp_who in QA to list the...

Wouldn't it be easier to just Replicate the data to the SQL Server from the Oracle Server? Surely Oracle has a Replication feature?