Re: Trouble with query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Adam Machanic (amachanic_at_air-worldwide.nospamallowed.com)
Date: 05/04/04 

Date: Tue, 4 May 2004 10:24:51 -0400

Depending on indexes and number of rows, it might be faster. If you start
having performance problems, try it out.

"Zoury" <yanick_lefebvre@hotmail.com> wrote in message
news:%23o6eyLeMEHA.3988@TK2MSFTNGP09.phx.gbl...
> Hi Adam! :O)
>
> > WHERE b.id <= #trans.id)
>
> That's what I didn't figure out!! Thanks a million!
>
> Concerning the Left Join query... woudn't it be slower?
>
> --
> Best Regards
> Yanick Lefebvre
>
>

Relevant Pages

  • Re: Authentication with .htaccess
    ... "Adam" wrote in message ... > it possible to use PHP to provide customised content depending on whether ... > visitor to a website is in a specific group or not? ... Mike Bradley http://www.gzentools.com -- free online php tools ...
    (comp.lang.php)
  • Re: o/t Greetings from Palm Springs!!!!
    ... 'ceptin', Adam, Americans ... You're pretty tender hearted, Adam. ... Yeah, well, I'm depending on you guys to keep me entertained until the ...
    (soc.culture.scottish)
  • Re: C++ exceptions in drivers
    ... keep in mind that also c++ exceptions end up in a kernel call. ... depending on how you using them, it can lead into performance problems. ...
    (microsoft.public.windowsce.platbuilder)
  • Re: QueryString Exists!
    ... There's 2 ways that I use, depending on the circumstances: ... > In classic asp I would do the following. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)