SQLFinancials extends the T-SQL scripting environment
by adding financial analysis functions similar to
those found in the MS Excel analysis toolpack, but
which can be used directly within the database.

Performing data analysis from within the database
tends to be much faster and more efficient than
transporting the data across the network to a client
application, and also allows simpler and cleaner
application architectures.

All the financial functions which have an equivalent
in Excel are numerically faithful to a very high
degree of accuracy, enabling easy migration of Excel-
based business operations to a database environment.

In addition, however, many of those functions are
effective over a broader range of input values than
their Excel counterparts, and there are some
additional functions not found in Excel.

Download (522 KB) Website Link to this page