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
--

• Next in forum: Re: Passing DateDiff rather than Actual Dates as Parameters
• Prev in forum: Re: PAGEIOLATCH is a lead blocker
• Thread view: Re: STORED PROCEDURE - passing table name as a parameter

[Reply to this message]