I have an application that is inserting a record every second. There
are thousands of periods from a few seconds to hours long where the data
in all the columns is identical thus causing hundreds of thousands of
duplicate rows.
Is there a way to set up the INSERT statement to allow the insertion of
a new row of data, where one or more columns has data != to the previous
insertion, but ignore or skip the insertion of a duplicate row?
Scott
--
-
The most effectual engines for [pacifying a nation] are the public
papers... [A despotic] government always [keeps] a kind of standing army
of newswriters who, without any regard to truth or to what should be
like truth, [invent] and put into the papers whatever might serve the
ministers.
Thomas Jefferson to G. K. van Hogendorp
Oct. 13, 1785. (*) ME 5:181, Papers 8:632
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------