I'm not sure if current releases of SQL Server include the infamous DeWitt clause (http://stackoverflow.com/questions/12115397/is-it-against-li...).