This discussion is archived
2 Replies Latest reply: Dec 3, 2012 7:32 AM by amin_adatia RSS

Unique Index violation when the data does not have any violation

amin_adatia Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points