Author: Marius le Roux
-
Stretch Imagination with SQL Part 2
Article Summary This article is about tackling a fun SQL challenge! The goal was to parse a spool file in a different way than usual, so I could show how to display the data in a table and automate the process. I also wanted to demonstrate how to handle repeating lines in SQL and how…
-
Stretch Imagination with SQL Part1
Scenario Let’s take a simple query like. It gives quite useful information, right? In fact, 109 columns of information that I have to scroll through all right through the screen. and so forth. Now, what if I want to track these metrics, say over a dimension of time, more easily? I have at my disposal…