On Feb 2, 2009, at 10:21 AM, Stephen Russell wrote: > > You answered your own Q. As you percolate through the data, your > inserting to your normalized table that has a UNIQUE compound index. > You try InsertHere and if a catch you total to counter for a > GotThatValue concept.
I get the point. Well taken. It could work for a few of my circumstances. There is so much crappy data in here, so many inconsistencies and redundancies that I was looking for a better way to do the generic common population. The phones and eMail were just a easy-to-generalize example. Your MAX() idea will work for many of them, too. I hadn't thought of MAX() in a character context. Thank you - - - -- Ken _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/74979a15-d36f-4f52-bf75-8dd001364...@information-architecture.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
