This was very useful... the SP by Hari.Sharma, and the reports tip by Williams.. Thanks for both of you guys

I Liked it 🙂

WHY???

you can use the following

[font="Courier New"]SELECT

x,

y,

COUNT(y) AS How_Many_Times

FROM t1

GROUP BY x, y

HAVING (COUNT(y) > 1)[/font]

I don't understand 1.why do you have to add a rowid!! 2.what...

Mark, your Idea is very nice 🙂

Hi,

I have faced the same problem. I tried to figure it out in the internet and I found this article

If you encounter this

Could not obtain information about Windows NT group/user...