That is great, too. Thank you, both.

S

Grasshopper,

That works, thank you! I don't understand why, so I am going to read up on how this query is constructed. 🙂

Thank you again.

I suppose another alternative would be...

I'm rereading the criteria, and maybe I need to state it differently:

If group TransactionNumber has at least one row with CancelDueToCorrection = 'Y', then that group count must be ...

Thank you, Grasshopper. One of the criteris is not met with this query:

where a transaction number exists more than once and where at least one existence has CancelDueToCorrection ='Y',

The...

Does no one reply if you accidentally post in the wrong forum? 🙂

...and apologies, I thought I was in the SSRS forum when I posted this.

Sharon

Very good - thank you both for the advice. I would have dropped the clustered index, btw 🙂 now I know not to...

Will be a lot of trial...

I see it now - thx again...

Jeff and all,

Thanks for posting this response - it did the trick! SELECT UPPER(CONVERT(VARCHAR(30),@ReturnValue,2))

However, I don't understand why. Would you mind explaining if you have the time?

Thanks so much,

Sharon