Ugg ... "The problem arises when there is more than one distinct value" ... then this wouldn't be a distinct value...

Semantics aside, if you have to nest cursors then I'd be saying go back to the drawing board and re-think the design. Sounds like someone went off on the wrong tangent.

If thats not likely then I wouldn't be expecting too much from your nested cursor routine.