>NN,
>It's a function used in evaluating a rule. The Low Bound is the boundary of a range that the incident (a driving violation) must fall into for the surcharge penalty to apply.
>
>The cursor is not used later.
>
>I think I have a working algorithm -- not exactly the same as I display here.
>
>Thanks
>Bill
I asked because if the cursor is not used later you can use select cnt(*) as CntAccidents ... into array instead. In other words, very close to the solution already proposed by Cetin.
If it's not broken, fix it until it is.
My Blog