Originally Posted by garrydawkins
... So, the data is all #$%%$*&*(T(*&^)$. No referencial intergrity. Were if it was database driven. I would not need to clean up data to produce back to a application that will continue to have bad data in the database tables.
If you try to fix (manipulate) the data in order to produce "acceptable" results, your customers (and developers) will get use to it and expect you to "fix" everytime the c.r.a.p. they enter (or allow to enter) the database.
If you cannot have the developers fix their own data, RUN as fast as you can.
Eventually they will blame YOU for the bad data.