Hi

At first sight I'd suggest you post your CREATE TABLE, INSERT and SELECT statements so that we can get a clearer picture of what you're trying to do.

Regarding your column...

Hi

Thanks for updates from both. I discovered that running the script again seemed to have the correct effect, so the expected updates were performed and not more than that....

Hi

I'm not sure which format you envisage this having but the idea is a brilliant one. I've spent 6 months searching for a site that would give me the...

Hey thanks for this.

I got this database as a sample - not sure where from - but it contains days and dates for a number of years in order to...