A subquery question 3

[Zoom1177]

Hi,

lets say i got this ONE table

Name________Sport
=================
Brian Soccer
Karen Golf
Barb Basketball
Terry Soccer
Mona Golf
Tim Basketball
Jack Golf

I want in ONE resultset to get the following

Soccer
=====
brian
terry

Basketball
==========
tim
barb

Golf
======
karen
mona
jack

What is the easiest way to do that using T-SQL?

Thanks

 

[r937]

if you have a 4-level hierarchy and wish to show them indented, this is definitely not something you should be doing in sql

have a look at this article, perhaps it will help you -- Categories and Subcategories


r937.com | rudy.ca

 

[Zoom1177]

Thanks r937, I will.