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.