SQLUtilities 1.0.0.0

SQLUtilities extends the T-SQL scripting environment by adding 64 new general-purpose functions for text, date/time and numeric processing that can be used directly within queries and stored procedures at the database layer.

Date and time functions include table-valued sequence generator functions that can generate `on-the-fly` date and/or time sequences of any length with any step interval (these can be used directly in joins, for example), random date and/or time generators, various working days calculations that take into account specified weekend days and holidays, and other general date and time arithmetic functions to complement what`s already available in SQL.

Numeric functions include a table-valued numeric sequence generator that can generate `on the fly` numeric sequences of any length and interval, a RANDBETWEEN function similar to the one in MS Excel, and a RANDOM function that does not require seeding between query rows in order to generate distinct random numbers.
In addition there are three relative-column reference functions that allow you to eaily retrieve the value of one column from the row in which the maximum value, the minimum value, or a specified value of another column occurs.