Tag: SQL

So, we got tired of playing Camel Cards and decided to throw some Jokers into the mix. This time, our wonderful friends the elves have decided that they don’t like Jacks but they do like Jokers. So, there are a few changes to our code that will need to be made: with cte as (…… Continue reading Walking Through Advent of Code Day 7 Part 2

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

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

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

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

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

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

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