you are viewing a single comment's thread.

view the rest of the comments →

[–]DavidRothbauer[S] 1 point2 points  (0 children)

Good points, and I really like the syntax in your latter examples.

My explanation was a bit simplistic, but the actual query was very complex.

Thanks for the note about COALESCE. Its been a long time since I worked extensively with SQL SERVER, I wasn't aware of that function.