> ...I'd love to write a business case > for your company outlining how they're hemoraging hundreds of > thousands of dollars every year by making their programmers spend > many, many extra hours coding by (among other things) reinventing > payroll every time they create a new business unit. :P
Well, I will say that we don't have to routinely write these nasty queries, it's only a few specific cases like what I described before. But the problem is that each business unit has different rules for how they do payroll. If we wanted to simplify things, we'd make /everybody/ follow the same set of rules, but unfortunately that's not possible in a large company like this. Also, part of the problem is that some of these databases were poorly designed (some of them are large enterprise applications the company bought, so there's no changing of the design). So we find ourselves fighting with bad designs, and thus producing nasty queries to get things to work. > ...I ended up sending a fairly detailed response which > explained how to store id's and labels for the properties in one table > and the values for properties in a 3rd so that the application would > have only 3 tables and require no additional schema changes rather > than continually adding columns or tables. So you described a 1-to-many bridge table. :) I know exactly what you mean. In fact, what you described is what we have to fight with all the time, because some of the designers of the databases we use don't understand good relational DB practices. ---------------- [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54