Data consistency is for lesser beings...

Argh. I'm glad that's over with for now.

I've just finished (I think) doing some data cleanup to fix the problem of half-a-dozen products being erroneously labeled with around 30-odd different combinations. That just sounds painful, rather than difficult, so throw in the fact that the software vendor restructured its licensing and sales model twice over that period and youll start to get an idea of how "interesting" the task turned out to be.

And then consider that the next time Ted E. goes into the database, he'll look at what I've done, decide it's too hard to understand and that consistency of data within a database is only a guideline (and a loose one at that), and begin creating new and wonderful product descriptions all over again...