Re: Query to provide range of repeat values

From: VC <boston103_at_hotmail.com>
Date: Fri, 20 Feb 2004 17:48:56 GMT
Message-ID: <RLrZb.353142$I06.3753097@attbi_s01>

Daniel,

Thank you for your kind words.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1077298341.778489_at_yasure...
> VC wrote:
>
> > Hello,
> >
> > I doubt that a stored procedure will be faster than a single SQL
performing
> > only one table scan.
> >
> > VC
>
> I'm quite sure you are correct. Rarely if ever are procedures faster
> than single DML statements. But my concern, mirrored by the OP, is
> one of maintainability. Add in the rest of what is required and only
> someone very senior could possibly maintain it.
>
Received on Fri Feb 20 2004 - 11:48:56 CST