Thanks, Dwain. Here's the only thing close I've found so far. I didn't realize it was in there until i retreated to the 2005 new features. The text below is copied from
2008 R2 Using Common Table Expressions
A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query....
A CTE can be used to:
...
Substitute for a view when the general use of a view is not required; (Emphasis mine)
...
Does anyone know of any other authority to add to that?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills