Use XLeratorDB/financial for a wide variety of financial calculations. The feature-rich XLeratorDB function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/financial includes SQL CLR functions for:

• Rates of Return - IRR, XIRR, NPV, RATE, DIETZ, etc.
• Bond Figurations - ACCRINT, PRICE and YIELD for both ODDF and ODDL coupons, etc.
• Loans - PMT, IMPT, CUMPRINC, AMORTSCHED, etc.
• Depreciation - DB, DDB, SLN, SYD,VDB
• Other Financial - EOMONTH, DOLLARFR, etc.

Click Here for the full Product Details

Realize the full power of SQL Server with in-database analytics. XLeratorDB lets you invoke dozens of standard statistical functions within the database – without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

XLeratorDB/statistics 2008 includes SQL CLR functions for:

• Descriptive statistics
• Statistical inference – specific tests - CHISQ, TTEST, etc.
• Correlation and Regression Analysis
• Data collection - STYEX
• Probabilities

Click Here for the full Product Details

Use XLeratorDB/math for a wide variety of mathematical calculations. The feature-rich XLeratorDB function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns. The documentation, below, includes sample SQL.

XLeratorDB/math includes SQL CLR functions for:

• Arithmetic/Algebra - PRODUCT, MROUND, etc.
• Trigonometry - ACOSH, SEC, TANH, etc.
• Number Generators - RANDBETWEEN, SERIESINT, etc.
• Interpolations - INTERP, SPLINE, etc.
• Matrix Functions  - MMULT, MINVERSE, etc.

Click Here for the full Product Details

Use XLeratorDB/engineering for a wide variety of engineering calculations. The feature-rich XLeratorDB function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/engineering includes over 40 SQL CLR functions for:

• Engineering – BESSELI/J/K/Y, ERFC, etc.
• Base Conversions – BIN2DEC, OCT2HEX, etc.
• Complex Numbers – COMPLEX, IMSQRT, IMREAL, etc.

Plus over 70 unit conversion functions for:

• Area, Length, Speed, Temperature, Volume, Weight

Click Here for the full Product Details

Use XLeratorDB/strings for a wide variety of string manipulations. The feature-rich XLeratorDB function library lets you include text manipulations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/strings includes over 40 SQL CLR for:

• Formatting – CONCAT, PARSE, TEXT, SPLIT, etc.
• Information – COUNTSTRING, FIND, ISALPHA, etc.
• Calendarizations – NETWORKDAYS, WORKDAYS,etc.
• Conditional formatting - IIFSTR

Click Here for the full Product Details

XLeratorDB/suite includes all functions from all of the XLeratorDB packages - functions to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel® you can now bring the power of those functions into the T-SQL environment.

Includes all of the functions from all of the XLeratorDB packages:

• XLeratorDB/financial
• XLeratorDB/math
• XLeratorDB/statistics
• XLeratorDB/engineering (includes unit conversions)
• XLeratorDB/strings

Click Here for the full Product Details

XLeratorDB/developer includes all functions from all XLeratorDB packages. For use with SQL Server Developer editions, use this package to perform all kinds of financial, mathematical, statistical, engineering, etc., calculations in the SQL Server environment. Presented in a format familiar to anyone who has used Excel® you can now bring the power of those functions into the T-SQL environment.

Includes all functions from all XLeratorDB packages:

• XLeratorDB/financial
• XLeratorDB/math
• XLeratorDB/statistics
• XLeratorDB/engineering (& unit conversions)
• XLeratorDB/strings

Click Here for the full Product Details