LifeinAsia - 8:24 pm on Sep 22, 2010 (gmt 0)
The problem with that is that MS SQL requires all values in the SELECT list to be contained in the GROUP BY clause.
I think that you will either need to massage the data on the application side (PHP, etc.) or use a CURSOR to loop through and massage the data.
Basically, you'll need to:
SELECT DISTINCT styles
Then you'll need to loop through each row of that data and find the first row that matches that style (and Category='Designer') and return the size and price data for that row.