BY Price
..or something like that
Steve
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Friday, 22 June 2007 1:52 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CF Query Question
Steve,
Are you sure?
SELECT
Howdy,
select loanno, LoanProgram, BorrowerName, LoanFacility, BorRate, InvstLoanRate,
SettlementDate, FeeFreeRate, OtherFeeRate, PenaltyRate, BorRate-InvstLoanRate
as lender_margin
from trails
order by lender_margin
(SQL Server)
Cheers,
Adam
From:
Cfoutput query=queryName groupBy=lender_margin
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
http://www.aegeon.com.au www.aegeon.com.au
Phone: +613 8676 4223
Mobile: 0404 998 273
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Friday, 22 June 2007 12:42 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CF Query Question
Select loanno,
LoanProgram,
BorrowerName
Hi Steve,
As per usual your suggestion solution is perfect
On Fri Jun 22 10:42 , 'Steve Onnis' <[EMAIL PROTECTED]>sent:
Select loanno,
LoanProgram,
BorrowerName,
LoanFacility,
BorRate,
InvstLoanRate,
SettlementDate,
FeeFreeRate,
OtherFeeRate,
PenaltyRate,
BorRate-InvstLoanRate