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
