I'm sure I've written about this before, but it comes up so regularly in the newsgroups that I thought I'd write an answer here. A table (probably an audit table) exists with a field that stores a date signifying when a change was made. You need to return a result-set which has a row for each period of time between modifications. For ...