The link on the left menu will show unread. It would be better if it show all the latest.

How do you know which answers go on the same row? Remember that tables aren't ordered by default.

Congratulations to Gail and Jeff for becoming the first SSC Gurus and probably didn't notice.
The new points system is going to devaluate the points. I might no longer be...

As said before, the OTLT (or anything similar) is a bad design.
However, it shouldn't be confused with a "Junk Dimension" when building a data warehouse. The junk dimensions are...

Just a basic approach using cross tabs to avoid massaging the data for pivot.
I also changed the old-syntax join to keep the code consistent and used table alias to...

Something like this?

WITH Months AS(
  SELECT DISTINCT dtMonth
  FROM [TOTALS]
  WHERE dtMonth BETWEEN '2014/01/01' and '2014/06/01'
)
SELECT N'SELECT sEntityCode
 ...