>I'm looking to count the number of incidents various ranges of months.
>
>Can the following query be done without the second procedural step -- purely in SQL?
>
>

>*******************************
>PROCEDURE GetViosInRange
>*******************************
>LPARAMETERS tcVioCat,tnLowMonths,tnHiMonths,tnLowBound,tnHiBound
>LOCAL lnRetVal
>SELECT * FROM WCDRVA ;
>WHERE mvrcat = tcVioCat ;
>AND BETWEEN(monthsago,tnLowMonths,tnHiMonths) ;
>AND drvseq = this.drivernum;
>INTO cursor thesevios
>lnRetVal = 0
>IF tnlowbound > 0
>   SKIP tnlowbound-1
>   SCAN WHILE RECNO() <= tnhibound
>     lnretval = lnretval + 1
>   ENDSCAN
>endi
>RETURN lnRetVal
>

IF m.tnlowbound > 0
 local array arrCount[1]
 SELECT cnt(*) FROM WCDRVA ;
  WHERE mvrcat = tcVioCat ;
  AND BETWEEN(monthsago,tnLowMonths,tnHiMonths) ;
  AND drvseq = this.drivernum;
  INTO array arrCount
 return iif( m.tnLowBound <= arrCount, min(m.tnHighBound, arrCount)-m.tnLowBound+1, 0)
else
 return 0
endif

Cetin