|
Home > Archive > Microsoft SQL Server forum > September 2005 > Multiple entries script...help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Multiple entries script...help
|
|
|
| Ok,
In one table, I need to find all instances of multiple entries of an
invoice number in the column InvoiceNumber.
For example, there may be more than one entrie of 321, 567, and 987
in column InvoiceNumber.
321 skin care product
321 vitamins
321 bottled water
567 rubbing alcohol
567 dental floss
987 fabric softener
987 tissue paper
987 marlboro cigaretts
Any help is appreciated.
Thanks,
Trint
| |
| Simon Hayes 2005-09-28, 7:24 am |
| select InvoiceNumber, count(*) as 'Occurrences'
from dbo.MyTable
group by InvoiceNumber
having count(*) > 1
Simon
| |
| Trint Smith 2005-09-28, 7:24 am |
| Simon,
Thanks!
Trint
..Net programmer
trinity.smith@gmail.com
*** Sent via Developersdex http://www.droptable.com ***
|
|
|
|
|