Formatting output so that data repeated between rows is not shown

First of all you can use SS Reporting Services. That has an option to suppress repeating cells.

In T-SQL you have to program, there is no switch for it.

Example for hiding repeating cells using CASE expression:

http://ift.tt/1hyMrAW

IIF is supported starting with SQL Server 2012: http://ift.tt/1hyMrB2

---

Kalman Toth Database & OLAP Architect SELECT Video Tutorials 4 Hours

New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012