Report Offensive Message

one.

I used to use it for things like reporting production quantities over last shift, day, week etc.

Slightly different derivatives for durations as well.

It's especially handy with an outer join where you want to report 0s in a particular time range.

Trying to do that in code, SP or application can soon have you doing some extremely inefficient stuff, like select everything that isn't there...