SQL Server 2008 R2: StreamInsight - User-defined aggregates

Posted by Greg Low on SQL Blog See other posts from SQL Blog or by Greg Low
Published on Sat, 08 May 2010 05:02:00 GMT Indexed on 2010/05/08 5:30 UTC
Read the original article Hit count: 291

Filed under:
I'd briefly played around with user-defined aggregates in StreamInsight with CTP3 but when I started working with the new Count Windows, I found I had to have one working. I learned a few things along the way that I hope will help someone. The first thing you have to do is define a class: public class IntegerAverage : CepAggregate < int , int > { public override int GenerateOutput( IEnumerable < int > eventData) { if (eventData.Count() == 0) { return 0; } else { return eventData.Sum()...(read more)

© SQL Blog or respective owner