Posted by David Portas on 11/30/05 14:31

Erland Sommarskog wrote:
> David's suggestion of a view is a possible way, although I don't think it
> can be an indexed view, as indexed views can not include the UNION keyword.
>

Erland, you are right of course. What I meant to say was "partitioned
view", which may be feasible assuming the OP has a partitioning column.

--
David Portas
SQL Server MVP
--

[Back to original message]