>>>
>>>SQL Server. Thanks for the suggestion.
>>
>>;with cte as (select Col1, Col2 from A where SomeExpr)
>>
>>select * from cte
>>UNION
>>select Col1, Col2 from table2 where Col1 in (select Col1 from cte)
>
>Thank you for the sample. Do I understand correctly that cte will work with SQL 2005 or later only, right?
Correct. CTE and many other great enhancements were introduced in SQL Server 2005. It will not work in SQL 2000.
If it's not broken, fix it until it is.
My Blog