Wayne Sheffield

My blog about SQL Server

Browsing Posts tagged import file

Next,  Advent of Code 2018 – Day 6 As I explained in a recent post, I’m participating in this year’s Advent of Code challenge, with the twist of doing the challenges in T-SQL. In case you don’t know what “Advent of Code” is, Eric Wastl (t) created it for the purpose of, as Eric describes […]

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a physical tally table.

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a recursive case-sensitive string replacement.

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a virtual tally table and getting data from prior rows.

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a running total calculation and duplicating a result set