Posted by Simon Hayes on 09/28/05 15:04

select InvoiceNumber, count(*) as 'Occurrences'
from dbo.MyTable
group by InvoiceNumber
having count(*) > 1

Simon

[Back to original message]