grouping levels without using Reporting Services 1

[NuJoizey]

I'm pretty sure the answer to my question is either "No" you can't do that, or "well, it is possible, but why would you want to because reporting services does it", but I'll ask anyway.

Using plain TSQL, is there a way to return a grouped recordset without the aggregation, that would look something like:

New York
CompanyName ManagerLastName
XYZ Corp Smith
ABC Inc Jones
Chicago
GHI Inc Johnson
PDQ LLC Barney
San Diego
LMO LLP Whaley
TUV Co Buffett

 

[jbenson001]

No way that I know of without using some sort of reporting tool or front end app.