Aggregated Query not working in Query Notification - Any i..

We are using an aggregated query for query notification

MSDN says you can use count_big() and sum() with group by clause.

select entry_date, count_big(entry_date) as cnt from dbo.my_stats where
entry_date > '2008-04-10' group by entry_date

entry_date is a column in composite key and hence its a NOT NULL column.

Any ideas why it is failing?

--
Murali Krishna,
www.connexuscorp.com