When SQL Server 2000 introduced user-defined functions I predicted that a few companies would release sets of cool financial/mathematical/statistical functions. It didn’t happen. When SQL Server 2005 introduced the CLR, I again predicted that a few companies would release sets of cool financial/mathematical/statistical functions written in CLR. It didn’t happen.
Enter www.WestClinTech.com. These guys have done it. They’ve released sets of Financial, Statistical, Math & Trig, Engineering, Unit Conversions, and String CLR functions. And they’re smart about it too. Rather than reinvent the wheel, they replicated most of Excel’s function, so when the business analyst’s model a formula, you’re all set.
I’ve started testing them and so far I’m impressed. If your application could benefit from moving complex calculations into the database instead of passing all the data to an iterative tier, then I suggest you take a good hard look at this company. This is exactly the kind of third-party product I want to see around SQL Server. Well done.