Can you be more specific? I can't say I would understand how to debug this problem again with the info you just provided.

TIA.

Please follow the thread to this adress :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=328091

Please follow the thread to this adress :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=328091

Please follow the thread to this adress :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=328091

Please post the real query you are using.  This error is not possible with this code on the specified column.

For the where conditions, make sure you are using the identifier...

What code did not work?

How did it fail (error, not returning the expected data)?

But now you see how you can get a subset of data using a more complexe group by, then self join to get the rest of the columns for those...

I strongly suggest you post this in the 2005 forums.  That's your best chance of getting help.

And please do not cross-post.  It doesn't speed anything up in the end.

I strongly suggest you post this in the 2005 forums.  That's your best chance of getting help.

And please do not cross-post.  It doesn't speed anything up in the end.

I strongly suggest you post this in the 2005 forums.  That's your best chance of getting help.

And please do not cross-post.  It doesn't speed anything up in the end.

Lol, I think I overcomplicated this one a little bit in the end .

select * from phbasic Main

INNER JOIN

(select EmpID, MAX(CheckNumber) AS CheckNumber

           from dbo.phbasic

           where t2.pay_period_end = '11/25/2006'

group by EMPID) dtMaxCheck

ON Main.CheckID = dtMaxCheck.CheckID

--optional but I doubt it is required

--AND Main.EmpID...

Yup that sums it up pretty good .

HTH.

Yup, so where did you say I had to send that resume?