Tag Archives: AdventofCode

Advent of Code 2017 Day 4–#SQLNewBlogger

Posted on January 18, 2018 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Advent of Code 2017 Day 4–#SQLNewBlogger

tsqlt Tests for Advent of Code 2017 Day 2

Posted on January 13, 2018 by way0utwest

This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on tsqlt Tests for Advent of Code 2017 Day 2

Advent of Code 2017 Day 1–#SQLNewBlogger

Posted on January 4, 2018 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the Advent of Code. I stumbled on the site a few years ago and enjoyed working through … Continue reading →

Posted in Blog | Tagged , , | 6 Comments

CROSS APPLY v InLine Functions

Posted on February 10, 2016 by way0utwest

While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which is done with the HASHBYTES function in SQL Server. This is a computation and given the problem, there is no … Continue reading →

Posted in Blog | Tagged , , | Comments Off on CROSS APPLY v InLine Functions