hamishahern ,

If you cast directly to int depending on the time portion of the datetime value you may get different DATES but ,...

the workstation used for keith does not belong to the DOMAIN where SS is!

-- join to the domain and you should be happy

HTH

On QA run

EXEC sp_updatestats

Take a look at BOL "statistical information, updating"

Client Network Utility is to be used well ... ON THE CLIENTS !!

No need for server to be there

You may have to give a little more detail but

assuming the value on the right is "the True" you can ponderate by position of the '1' and in that...

CREATE PROCEDURE [dbo].[prc001GetTipOfTheDay]

 (@intStaffID int)

AS

Select Top 1 intTipID,strTipDesc

 From tblTips

 Where intTipID > isnull((Select IsNull(intLastTipID, 0) % (Select Max(intTip) from tblTips) from tblStaff Where intStaffID = @intStaffID),0)

 Order by intTipID

The Machine name can be ALIASED with the Network Client Utility!!

Because the column does exists SS is trying to find out what is the purpose of the query an generated a plan!

IN SS 2000 (FROM BOL)

Referencing Objects

SQL Server allows the...

OR

if you need one Free: get This one

Yep becareful if you are doing this on a heavy used table it may get really bad. Try to use a separed table where you from the trigger store the...

I never meant that with more arithmetic could be done I just meant straight to int .That is why is a good thing to know about the actual storage format that is...

I got this right because I noticed EM was hidden in the question

But the anwer was not very clear and I had to Assume...

I have seen that before and YES you are correct is using the filed name of the wrong table:

One of the Best practices that MS is distributing with the SQL Server...

DO NOT Cast datetime to any type of int !!!

Better

Left(<datetime>,11) 

or

SUBSTRING(CAST(<datetime> AS binary(8)),1,4)

or

.... Like above

SELECT *

FROM  Events E

 JOIN

 (

SELECT personID, MIN(eventTime)

FROM         Events

GROUP BY personID, CONVERT(char(10), eventTime, 101)

) EMin On E.PersonID = Emin.PersonID and E.EventTime = EM.EventTime

ORDER BY personID