SQLUtilities

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 whats 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.