SQL 2005: CTE Example

WITH MyCTE (Col1, Col2) (
SELECT Col1, Col2 FROM MyTable
UNION
SELECT Col1, Col2 FROM MyOtherTable
)
SELECT * FROM MyCTE