The XLeratorDB function library inlcudes a RANDBETWEEN scalar function which works just like the EXCEL RANDBETWEEN function. You could have just included RANDBETWEEN(1, 5) in your select and you...

We provide a suite of functions replicating EXCEL functions for SQL Server using SQL CLR. Based on the traffic to our web site (www.westclintech.com) it is clear that there are...

You should be careful with this function, as it will produce zero in situations where you otherwise would expect a non-zero result. Since none of your calculations are parameterized, you...

You can find the equivalent of EXCEL functions which can be called in T-SQL at http://www.xleratordb.com.

You could think about this in a completely different way. There is at least one third-party function library that provides every EXCEL function as a user-defined function (go to