I would appreciate some advice on how to detect duplicate values for a column in a table. Apart from using a cursor to go through each row and then looking for rows with the same value is there any quicker way of doing this ?
Any suggestions would be appreciated. Thank you. Regards, John Docherty

