Inserting Blank Line in Output

[charbrad]

I am trying to insert a blank line between categories. My output is:

Shoes  12
Shoes  11
Shoes  10
Shoes  09
Socks  19
Socks  11
Socks  17
Socks  22
Boots  19
Boots  25
Boots  76

What I am trying to get is each category with a blank line in between like:

Shoes  12
Shoes  11
Shoes  10
Shoes  09

Socks  19
Socks  11
Socks  17
Socks  22

Boots  19
Boots  25
Boots  76

Can someone help me out?

 

[vbkris]

i have assumed that the Table name is ProductTable, the columns are Product and Price (tinyint).

query:
SELECT CASE WHEN Price IS NULL THEN '' ELSE Product END Product, isnull(cast(Price as varchar), '')
FROM (SELECT *
FROM ProductTable
GROUP BY Product, Price WITH rollup) DTable



Known is handfull, Unknown is worldfull