It's times like this that I feel like I don't read enough . . . Apparently SQL Server 2005 added a great new concept called a Common Table Expression (CTE) based on the ANSI SQL-99 standard. Essentially, these allow you to create an on-the-fly view that lives only in the scope of the current... [More]