One option your have to accomplish this is to use the "IN" operator and return only the Employee_code in your subquery

Like :

SELECT *

FROM Employee_Absence_Days

where Absence_start_date >= @DATE1 AND Absence_start_date...

Hi Phillip,

Yes the databases have been upgraded from SQL Server 2000 (32 bits) to SQL Server 2005 (64 bits)

This is not the first time that DBCC CHECKDB runs and it...

Hi Paul and Phillip,

When I say it "failed", I meant that the server completely hanged, we couldn't connect to it or even ping it. Everytime this happened, the server...

1. this is true

2. you can't sum directly on a bit field because of the internal representation of that type of field in SQL Server. To accomplish what you...

Hi,

Here are the results if the DBCC CHECKDB ('MyDatabase') WITH ESTIMATEONLY :

Estimated TEMPDB space needed for CHECKALLOK (KB)

4737

Estimated...

Hi,

I'm having the exact same issue on a production server that is almost identical as yours.

- SQL 2005 SP2 64 bit running on W2K3 SP2 64

- Two Xeon...