• GilaMonster - Saturday, December 30, 2017 1:08 AM

    If the DB doesn't have constraints, finding the columns they should be on will likely be the least of the problems. Fixing the data so that constraints can be added will likely be a whole lot harder.

    No disagreement there, but we need to start somewhere - open to suggestions. Since the software has been built in house and looks like it is staying that way, we won't be able to just migrate away from the current DB. Current initiatives are moving everything to views/sps, and I'm looking at this idea about the joins.