Re: Look ahead 2 rows

From: craibuc <craibucNOcrSPAM_at_hotmail.com.invalid>
Date: 2000/07/12
Message-ID: <0a82d390.1dfdd2ed@usw-ex0105-035.remarq.com>#1/1

"Id I can use"? Not sure what you mean.

Unfortunately, this is the logic that must be used. Each row represents a property. Some of these properties may have sold during the year. If they have sold, I must identify an adjacent property and make a statistical comparison between the two.

Other than moving through a cursor, there doesn't appear to be an easy way to do this, especially when some of the additional business rules are considered.

Craig Buchanan
Cogniza, Business Intelligence Specialists www.cogniza.com
+1.612.824.5858

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT