I recently used LAG for calculating the difference in values between two rows in an ordered set. It was for a manufacturing application in which product weights are recorded...

A dates table can provide all of those answers, and more.

Even though our software team varies between 4 and 6 people, it would be a disaster not to have all issues logged, classified, and worked through Jira (www.atlassian.com) and all...

That's right, John. I tested my scripts only in 2008, so I thought it appropriate to indicate that. I'm sorry if the title gave the impression that there...