Search for: subquery

Session: Unraveling Tangled Code

Here is the landing page for my session, “Unraveling Tangled Code”. Here you’ll find downloads and links to recordings, as I can get around to placing them. Feel free to ask me questions via email, Jen at MidnightDBA.com (or on Twitter)! Abstract: Once upon a time, you inherited an application or a database that was […]

T-SQL: CASE Statement

This is a companion piece to the MidnightDBA video T-SQL: CASE Statement. In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data.  Simple CASE Let’s take a simple example. We want to […]