Category: SQLBasics
-
Walking Through Advent Of Code Day 7
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…
-
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. 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 Code Day 5. This time I made it…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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”?”…
-
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…
-
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…