Aggregated Query not working in Query Notification - Any ideas
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?
|<Prev in Thread]
||[Next in Thread>|
- Aggregated Query not working in Query Notification - Any ideas,
Murali Krishna Siruvuru <=