"Randy" wrote:

> Hi Gurus
>
> Need some help. I have a account table with the following columns. I want to
> only see the first date the account threshold is >= 105 or 120 under
> theOCLWatch column. However, if I have consecutive dates that exceed my
> threshold I only want to see the first time it exceeds 105 or 120. I want to
> evaluate every record in the account table and only return the first time my
> account exceeds the treshold. My account could exceed the threshold in day 1
> then go under the threshold in day 2, then go back over the threshold in day
> 3. In this case I ony want to see Day 1 and Day 3. I am thinking I need a
> varaible and cursor. I need to partition this by account because my table may
> contain multiple accounts. Any help would be greatly appreciated . Example
> Below(USING SQL 2005)
>
>
> SELECT
> Date
> ,AccountId
> ,CurrentBalance
> ,CreditBalance
> ,CurrentBalance/CreditLimt*100 as OCLWatch
>
> FROM Account
>
> ORDER BY Date ASC
>
> Sample Results:
>
> Date Account CurrentBalance CreditLimit OCLWatch
> 12/1/05 123 208 200 104
> 12/2/05 123 209 200 104
> 12/3/05 123 211 200 105 Want to
> see this only
> 12/4/05 123 211 200 105
> 12/5/05 123 211 200 105
> 12/6/05 123 150 200 75
> 12/7/05 123 225 200 125 Want to
> see this only
> 12/8/05 123 225 200 125
> 12/9/05 123 209 200 104
> 12/10/05 123 211 200 105 Want to
> see this only
> 12/11/05 123 225 200 125 Want to
> see this too!!
>
>
>
>
>
>
>