Identify duplicates

[BryanR]

Hello All,

I've got what I believe to be a fairly simple question, but I am relatively new to the Telerik and VB "community", so bare with me PLEASE.

I've written a union statement that will bring back a report that looks something like this:

Name     Plan      Plan Code
-----------------------------------
Will        1A         XYZ  
Will        2A         ABC
Mary      1A         XYZ
Mary      1A         XXX
Mary       2A        ABC
Sam       1A        XYZ
Sam        2A       ABC

I'm trying to set up a report to identify duplicates.

I would like to identify Mary because she has 2 plan 1A's with different plan codes. Simply to show both the 1A rows for Mary either bolded or italicized, etc. I don't want to remove it because this is for an auditing process for our database. How can I achieve this?


T.I.A.,
B

[Hadib Ahmabi]

This isn't exactly a "fairly simple" question. You will have to iterate through the data manually in order to determine the duplicates.

[BryanR]

I've just wrote it into my query. It works great, but wanted to see if there was a more graceful way to do it through telerik.

Thanks for the response, though. Appreciate it.