r.hensbergen (3/23/2009)
I like these questions a lot more than making 'SQL puzzles', just by showing bad code. Your question is a typical sample of what I run into daily. Every DBA should use ISNULL in their queries, I guess that's the lesson for today 🙂
Actually,
They should use COALESCE, it's much easier to use, doesn't request nesting for multiple tests and is ANSI SQL compliant.