This seems to be more of an HTML/CSS formatting question than a SQL Server question, so perhaps try this:

1. Take the HTML created by the code you posted and output...

will.byrne (11/9/2012)

---

... I keep getting NULLS in the new PlantName column from the SELECT statement and it doesn't seem like it's bringing over the data associated with the "ALL"...

geoffrey.sturdy (10/25/2012)

---

Dave

"To my knowledge no vendor provides this, and I doubt any ever will. "

Burroughs/Unisys provided the "printaudit" program to do just that for their DMSII database , and...

The rows are not "unnecessary", they are just the result of a "cartesian product" (or "cross join") - described here - because not every table in your view is in...

When people say "SQL Server", they are not talking about the language "SQL". They instead are referring to the name of a Microsoft database product ... I'm just guessing...