Would now be a good time to bring up the "SQL-Server-2000-only-recognizes-every-3rd-millisecond" limitation? That one used to bite me in the butt. BOL covers this topic for those who are interested...
Accounting for NULL values can be tricky. Do you have a date that would make a good substitute for NULLs? For instance, if you know that DateSubmitted could...