Tag Archives: tsqlt

tSQLt Tests for Advent of Code 2017 Day 4

Posted on January 19, 2018 by way0utwest

This is day 4 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 4

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

Testing a Birthday Month Query

Posted on December 4, 2017 by way0utwest

I ran across a post from a tester, wondering  how to write a query for birthday months. This makes sense, as I’m sure some businesses want to notify or track customers that have birthdays this month and give them something. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Testing a Birthday Month Query

SQL Grouping on Sums (with testing)

Posted on September 25, 2017 by way0utwest

I ran across a post recently that I thought was an interesting T-SQL problem. The user wanted to group values into a running total, but the groups would reset based on a sum. In this case, the user had this … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Grouping on Sums (with testing)