This months T-SQL Tuesday comes from Matthew McGiffen who has given us the topic of “Puzzles”, thank you for a great topic!
Puzzles can be fun or frustrating, but I like them because it can be a great way to showcase who you are and how you work. For example, I was given a puzzle from a company that was interested in me but wanted to know how I approached specific problems. They gave me a simple SQL query and three word problems to go along with it. My reply back illustrated how I approach problems, document findings, performance test, and also work to obtain business requirements.
I gave them back a long paper that broke down the primary problem into nine different scenarios for how to interpret their question and I wrote a total of 35 queries spanning all nine scenarios to pick the best option. This included a procedure they could run to test these scenarios and see my work.
You can find the procedure here on my github, you will need to alter line 56 with the options 1-9 to test a scenario.
Continue reading “T-SQL Tuesday #114 Puzzle Party”