Permutations, Combinations, Sequences and Random Numbers

Hello everyone! I am back with a new set of puzzles (18 to be exact). As the title suggests, these 18 puzzles revolve around permutations, combinations, sequences, and random numbers. And of course the solutions are provided as well (written in Microsoft SQL Server's T-SQL). This set of puzzles includes using recursion to create a … Continue reading Permutations, Combinations, Sequences and Random Numbers

Stored Procedures: Returning Data Using a Result Set

For this article, we are going to examine the benefit of using stored procedures that simply return a result set (i.e. a stored procedure that has a SELECT statement). Before we do a shallow dive into this functionality, it is worth noting that SQL Server has 3 methods of returning data from a stored procedure: … Continue reading Stored Procedures: Returning Data Using a Result Set