Well, I figured out a way... I created a temp table with the ouput'd Id's, then did a join to the main table...

Thanks to everyone for all the help.....

Mike

It doesn't matter which of the dupes I show...... Any ideas? This is a one time thing, so it is probably not worth the time to normalize the table.....

Thanks much....

Is there a way to see the Name though - I need it on the report as well....

Thanks.....

Yes I did try your query and it appeared not to work.

Upon closer examination I know why - If the ID is the same but the Name is different it...

The table design is:

int ID;

nvarchar Name;

float Sort;

Original Contents:

ID Name SortOrder

--------------------------------

1,Mike,3

1,Mike,7

2,Joe,2

3,Ed,1

4,John,4

4,John,0

The desired output is:

4 John 0

3 Ed 1

2 Joe 2

1 Mike 3

Ordered by "SortOrder", with only 1 value (any 1) of...

The desired output is:

4 John 0

3 Ed 1

2 Joe 2

1 Mike 3

Ordered by "SortOrder", with only 1 value (any 1) of "Id" displayed.

Didn't work, that returns multiple copies of the records (More than are even in the DB)!