在select语句中嵌入的(相关)子查询中的别名。

My work is running SQL Server 2008 and I spend a lot of time querying the database for information as a side piece to my job. If I need information that isn't at the same aggregate level as my dataset I use an embedded query in the select statement. Usually it's 2 or 3 slightly different versions of the same number, so they both query the same tables. (See example below)My work is running SQL Server 2008 and I spend