Create Your Own Aggregate
Have you ever flipped the pages of Books Online, only to find that the aggregate function you need is simply not there? So why not add it?
Ever since SQL Server 2005, you can easily create your own aggregate functions. All it takes is a bit of .NET code.
This session will show you exactly how to create a CLR user-defined aggregate function, and how to use it in your queries. But it will also show you many workarounds to avoid having to do this for many commonly requested aggregates.
Sorry, there are no downloads available for this session.
Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server.
In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. For his contributions to the SQL Server community, Microsoft has given him the MVP award in 2006, and every year since.
The video is not available to view online.