Re: Query to provide range of repeat values

Hello,

I doubt that a stored procedure will be faster than a single SQL performing only one table scan.

VC

"Joe Mellors" <joemellors_at_aol.com> wrote in message news:53566469.0402200633.5a36046e_at_posting.google.com...
> Thanks for your help.
> We are writing a web application that displays this kind of data (but
> obviously not as simplified) and for a large number of tables. Many of
> the select statements will be joins across a few tables. I think your
> approach is very impressive but overly complicated for reuse
> throughout our application.
> We may have to reconsider a rework of the tables or use a stored
> procedure.
> But it was useful to see this technique so that it is available to us
> if we change our minds (and we would probably use it in a View).
>
> Joe
Received on Fri Feb 20 2004 - 09:00:53 CST