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

• Next in forum: Re: Multiple entries script...help
• Prev in forum: Multiple entries script...help
• Thread view: Re: Multiple entries script...help

[Reply to this message]