http://www2.sqlblog.com/blogs/adam_machanic/archive/tags/derived+tables/column+names/default.aspxTags: derived tables, column namesenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/08/bad-habits-to-kick-not-using-as.aspxFri, 09 Oct 2009 02:33:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:17387Adam Machanic22http://www2.sqlblog.com/blogs/adam_machanic/comments/17387.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=17387Aaron has recently been doing an absolutely fantastic series of posts detailing various "bad habits" that many of us pick up somewhere along the way. These coding anti-patterns aren't going to crash your server, but they will make your code more difficult...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/10/08/bad-habits-to-kick-not-using-as.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=17387" width="1" height="1">as keywordbest practicescolumn namesderived tableshabits