Several times I have run into a conversion where I have needed to take a table that stores key value pairs into a table that lists all values for a given record. The table look something like this: What I really wanted was something like this: This is kind of…

Okay, now that we have the general framework we can start writing the pieces that deal with the values that were given to us in the puzzle. The first thing I’m going to do is create a table that contains each possible value for each cell based on the values…

In this post, I’ll be diving deep into the code that was presented in this post. Recursive CTEs My solution utilizes a lot of recursive common table expressions (CTEs). CTEs are a simple way of defining a temporary projection in T-SQL that can be referenced multiple times later on in…

I’ve seen a couple examples of using SQL to solve sudoku puzzles, but most of the ones I’ve seen have used loops or cursors to cycle through and create a correct answer. I feel like if you make a solution that’s procedural like that, you might as well have done…