Download Northwind and Pubs Demo Databases
Installation of SQL 2005 Express does not include the good ol' Pubs and Northwind databases that we have come to no and love. Here's how to download them.
Reflexive Join - Statistics Time between status changes
If you have a audit-history, and you want to know how much time was spent on each "phase", "step", or "status", this computes the time before the status column changed.
