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 […]
Search for: subquery
T-SQL: CASE Statement
For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of my more popular golden oldies, like this one (original post here: http://wp.me/pZM1Z-oB). And be sure to drop by our live weekly webshow, DBAs@Midnight, at 11pm Central time on Fridays! This is a companion piece to […]
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 […]