Re: Boolean complement of a pair of OR clause

Jacob Salomon wrote: > > WOW! That sounds like an esoteric topic! > > I have data in a temp table ready to be inserted into a main table. > However, the main table has two columns, each of which must remain > unique. (So why don't my users allow me to create uniqueness > constraints? That's another story. Grrr!) So before I do the > INSERT INTO main-table SELECT * FROM temp-table> I run a query to see if there are any rows in the temp table that, if > inserted to the main table, would violate the above conventions. > ..SNIP.. Although I read from other contributors that this is a NULL problem, the version 7 SET VIOLATIONS statement is wonderfully useful in sorting out this sort of problem. You can get it to ignore constraint violations so only the unique rows are loaded. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.