Login     Register

        Contact Us     Search

XLeratorDB - Windowing Function Package


XLeratorDB/windowing package provides advanced windowing functions for SQL Server. Use XLeratorDB/windowing to gain access to some of the windowing and analytic functions in SQL Server 2005 and 2008 that have only become available in SQL Serve 2012, plus several new Window functions that are not otherwise available in any version of SQL Server.


XLeratorDB/windowing includes functions for:

  • Lag
  • Running Count, Sum, Avg, STDEV, VAR, etc.
  • Moving Count, Sum, Avg, STDEV, VAR, etc
  • Running Slope, Intercept, Forecast, etc.
  • Moving Slope, Intercept, Forecast, etc.
  • Moving Averages
  • Moving and Running Kurtosis, Skew, T-Test, etc.
  • Inventory Calculations - FIFO, LIFO, etc.

XLeratorDB / windowing - Documentation

SQL Server 2005 and 2008 have a very limited number of SQL Window functions. XLeratorDB/windowing provides many useful windowing and aggregate functions that you can use in SQL Server 2005, 2008 and 2012. The windowing package demonstrates innovation driven by our technicians and function designers.

They are designed by leading industry professionals and utilize comprehensive testing harnesses to ensure accuracy. These XLeratorDB functions have been built with input from industry professionals and are offered as part of the XLeratorDB function package collection for Microsoft SQL Server.

All XLeratorDB functions are fully documented online and include a host of examples.  Plus you are provided with support via email and phone.  Don't see the function you need? - let us know!




“Before XLeratorDB, there was no easy-to-use, built in solution for XIRR calculation in SQL Server, XLeratorDB is the first product to bridge that gap and streamlines the process for us.

Munish Kumar
Investment Analyst
The Sentient Group

"This is a very data processing intensive system that would not be possible without the use of XLeratorDB and SQL Server. XLeratorDB has made us a 15X return and it offers 500 times the processing that Excel is capable of."

Kenneth Jones
Founder and Managing Partner
Fusion Ventures

"We’ve saved as much as 20-30 percent of total development time thanks to XLeratorDB, With XLeratorDB, we can give our clients the means to automate many of their underwriting decisions, lowering their costs and reducing errors."

Jason Daniels
Chief Operating Officer
Verde International

"Any company currently using the Excel kernel within its applications to handle complex calculations will find XLeratorDB most beneficial, It’s an overall great product – flexible, yet reliable."

Chet Cotter
Director of Financial Systems
Newland Communities, LLC

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service