I know... Just throwing ideas around.

Or maybe you need to type a little faster... but that one was a close call.

Talking about call, the week-end is calling here.

L8r guys.

HTH.

C u monday .

Are you viewing the output in QA?

If so there's a default result max size of 255 characters... maybe that's the problem.

Nice guess I guess .

We need to see the expected output too. Help us help you.

If you have 20 wood categories, then put 20 different entries in the category table. Now you can add a category type to that table so that you can...

Declare @A table (id int not null, Name varchar(15) not null, SortOrder tinyint not null)

Insert into @A (id, name, SortOrder) values (1, 'Mike', 3)

Insert into @A (id, name, SortOrder) values...

This will kill the performance if not written right... Can we see the code?

I want a recount.

Just happens to be true unfortunately.

Now unless you have a cross join, that's just not possible. Post the actual data, table definition and the expected output and you want usefull help.

Didn't mind trying a guess... took only 15 secs to write it .

Slow down what???

Select id, Name, Min(SortOrder) as MinSort from dbo.YourTable

group by id, name

order by MinSort

Depends on how you want to use this data and the design of the form/report...

How about not including the column at all in the select?