We have always just used an Ending Date column which is only null on the last record. It's nice to see other solutions to this common problem. Great job on...

If in fact 'the older logs are not used at all' as you state, you simple need to create a table to track whether or not a purge has taken...

Ditto on the TI-99/4a!..and much the same experience as the OP...writing small programs to solve algebra and physics problems. I even bought the Extended Basic cartridge but the cassette interface...

Yep, posted a little hastily! Thanks!

syntax is certainly wrong unless it is a char type in the answers. For an int type this works:

UPDATE table1

SET ...

At work or shopping, I park well away from the entrance, as I can use the exercise. My wife complains, so I don't park quite as far out when she...

I can tame my cell phone. I don't answer it if I am busy..it's everyone else's that drive me crazy. I can hardly have a conversation with my spouse anymore...

When used appropriately, Access does the job quite nicely. I can package an Access database in an installer and have a customer up and running in minutes. (and they dont...

I really just guessed after about 30 seconds of trying to follow the logic. Only off by 1.0000!

I know that the intended database environment for this question was SQL Server so the answer is yes, however if running T-SQL against an Access database, the answer is no....