decentflower,

Try this:

SELECT * FROM @tbl t JOIN

(select sort,type, Max(price) AS price , name from @tbl group by sort,type,name) mmax

ON t.sort = mmax.sort AND t.type = mmax.type AND t.name =...

The table-valued function [dbo].[TableFormDelimetedStringWithoutNumberList] will choke on lists longer than 100 elements. Here's the error:

Msg 530, Level 16, State 1, Line 1

The statement terminated. The maximum recursion 100 has...