quote:

---

SELECT eventname, MAX(Status) AS Expr1, MAX(RecordUpdated) AS Expr2

---

set nocount on
declare @eventQueue table (eventname varchar(10), status int, recordUpdated datetime)
insert @eventQueue values ('tg', 10, getdate())
insert @eventQueue values ('tg', 9, getdate()+1)
insert @eventQueue values ('tg', 8, getdate()+2)
insert @eventQueue values ('yak', 10, getdate())
insert @eventQueue values ('yak', 9, getdate()+1)
insert @eventQueue values ('yak', 8, getdate()+2);

-------------------------------------------------------------
--2005
with yak (eventName, status, rowNumber) as
(
	select eventName
		,status
		,row_number() over (partition by eventName order by RecordUpdated desc)
	from	@EventQueue
)
select	eventName
	,status
from	yak
where	rownumber = 1
order by eventName

-------------------------------------------------------------
select eventName
	,substring(max(convert(char(23), RecordUpdated, 121) + convert(varchar,status)), 24, 10) as status
from	@eventqueue
group by eventName
order by eventName

-------------------------------------------------------------
select eventName
	,status
from	@eventQueue eq
where recordUpdated = (select max(recordUpdated) from @eventQueue where eventname = eq.eventName)
order by eventName

output:

eventName  status
---------- -----------
tg         8
yak        8

eventName  status
---------- ----------
tg         8
yak        8

eventName  status
---------- -----------
tg         8
yak        8