In racking my brain about how to do a Select Distinct that is ordered by a field that is not in my resultset, I came across this very clever solution from Jeff Smith's Blog to avoid the error message below. This solved literally hours of future head banging and I am going to remember this one for sure in the future. It is currently my favorite SQL Server tip of all time.
Msg 145, Level 15, State 1, Line 4
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.