finding reps that try to cheat the system... finding duplicate data in

[Zen216]

Hello All,
I have a table that stores data about when a rep emailed a client information. Sometimes reps change the email on one client's account to email themselves, or someone else info,, basically cheating the system. I would like to query this table to find out the duplicates..

the table has 5 fields,ID, work_folder_ID, email, datetime, user

what I need is to be able to return all fields where the email is the same, but work_folder_ID is different.. and group it by user

so if user A sent 10 things to client A, all of those would have the same work_folder_ID, if user A sent 10 things to client A, and 1 thing to client B, but used client a's email address, I would like to see the two different work_folder_id that has the same email, and then group by user, so I can find out who sent it...

hopefully this makes sense

using sql server 2000 std on windows server 2003


Thanks Everyone

 

[gmmastros]

It's hard to tell, but I think the query you are looking for is:

Select user, work_folder_id, email
From   YourTable
Group By user, work_folder
Having Count(*) > 1
Order by user, work_folder_id

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom