although i love the thought of the AffectingConvertWarning Types in 2012 ( Denali CTP3), i fear that they may be to noisy to be of practical use.
For instance this statement :
from Sales.SalesOrderHeader SOH
join Sales.SalesOrderDetail SOD on
SOH.SalesOrderID = SOD.SalesOrderID
throws the warning.
I know the answer already ( :) ) , but can the warning be restricted to :
Group by clauses
Order by clauses