An interesting example using a CLR aggregate function to perform linear regression. I’ve done a linear regression within an SSRS custom chart component (to draw a trend line), and I have done text string concatenation using a CLR aggregate, but I never thought of doing this. I don’t know that I ever WOULD do it, but I thought I would pass it along anyway.

A genuine use for a SQL CLR Aggregate – SQLServerCentral.