No longer are we racing… Now, we’re playing cards. Not just any cards though. This time we’re playing Camel Cards – if you get the gist of poker, you can get Camel Cards fairly quickly. As always, have some fun trying different ways to push the data into your SQL Server. Why not try using…… Continue reading Walking Through Advent Of Code Day 7
Category: SQLBasics
Walking Through Advent of Code Day 6 Part 2
Yet again those little elves have been devilish and messed up our input format. This time, they put spaces in our data. https://youtu.be/JuCMJWSK6Bk?si=OOcOqn2JjWwpgnLb You put Chocolate in my Peanut Butter! Sadly, this does make our numbers rather large, so we’re back to using the big ole Tally table we created for Walking Through Advent of…… Continue reading Walking Through Advent of Code Day 6 Part 2
Walking Through Advent of Code Day 6
Today we’re going racing! Sadly, it’s so not F1 or NASCAR racing. Snail racing is more like it since we’re moving millimeters by the end, but at least we’re closer to getting snow back to the elves, so let’s go racing! Given a few numbers that are times and current record distances, this actually doesn’t…… Continue reading Walking Through Advent of Code Day 6
Walking Through Advent of Code Day 5 Part 2
Part One of Day 5 had lots of reference tables. And, as always, our elves have changed the rules of the game with part 2. This time, the meaning of the seed numbers is slightly changing on us. Instead of it only being 20 seeds we have to cross-reference (at least that’s how many seeds…… Continue reading Walking Through Advent of Code Day 5 Part 2
Walking Through Advent of Code Day 5
Yes, that’s right my friends! We have reached day 5! There was a lot going on with this one, so let’s go ahead and get started. First thing we want to do, as always, is to go ahead and load all of our data into SQL Server. With this one, I cheated a little and…… Continue reading Walking Through Advent of Code Day 5
Walking Through Advent of Code Day 4 Part 2
Day 4 part 1 worked very smoothly. Let’s see what part 2 holds in store for us. With part 1, we just had to figure out how many times each of the winners showed up. With part 2 though, we have to jump through several hoops since we now have to determine how many cards…… Continue reading Walking Through Advent of Code Day 4 Part 2
Walking Through Advent of Code Day 4
After Day 3, I’m glad at least some of you made it back for Day 4. Today, we get to work with scratch-offs and a lack of getting the right winning numbers on the right cards. Sounds like a normal Thursday night for me… Now we get to work with a set of numbers that…… Continue reading Walking Through Advent of Code Day 4
Walking Through the Advent of Code Day 3 Part 2
Hopefully, by now, you’ve read my post Walking Through the Advent of Code Day 3. After looking through it, you’re probably thinking… “What have I gotten myself into? Is SQL the way to go with all of this? Can I back out now and learn a programming language that AoC can be done in “easily”?”…… Continue reading Walking Through the Advent of Code Day 3 Part 2
Walking Through the Advent of Code Day 3
Today, we’re starting on Day 3 of the #AdventOfCode series. There’s a lot to cover here, so let’s get started, shall we? As always, we must load the data into our database. In my case, I’m loading it into a table called AOCDay3 – memorable and easy to type all in one. The first thing…… Continue reading Walking Through the Advent of Code Day 3
Walking Through the Advent of Code Day 2 Part 2
So many days of Advent! So many chances to practice SQL! Today, we’ll be working on the next in the series using the data and processes that we found yesterday in Day 2 Part 1 – found here. Thankfully, we were smart when we began working through the data and we have the data for…… Continue reading Walking Through the Advent of Code Day 2 Part 2