what query analyzer said....
too much too long, can get better data quicker calc'ing in cf.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 12:50 PM
To: CF-Talk
Subject: RE: sql question pt 2
with about 5000 lines coming from sql server, if I do the math with a cfloop
and cf tags in between, versus, calculating in sql server and discarding
what I don't want....?
what do you think?
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 12:48 PM
To: CF-Talk
Subject: Re: sql question pt 2
Tony Weeg wrote:
>
> isnt there just a way to use those calculated values, referenced in
> the beginning of the query, later on down in the query?
SELECT
*
FROM (
SELECT
count(tony) as tonysCount,
sum(jayme) as jaymesCount
FROM
orders
) a
WHERE
Abs(tonysCount-jaymesCount)/tonysCount) > 0
Whether this is faster depends on the circumstances.
Jochem
________________________________
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
