2 Replies Latest reply: Dec 3, 2012 9:32 AM by amin_adatia RSS

    Unique Index violation when the data does not have any violation

      I have a table with a 7 column unique index

      I do select <unique index columns>,count(*) from <queue_table> group by <columns> having count(*) > 1;

      I get no rows.

      When I try and insert into <working_table> which has the unique index in place, I get the error

      Edited by: amin_adatia on 3-Dec-2012 7:30 AM

      PLease ignore this ! Bad code on my part. Sorry.