• @PSB,

    Where you able to solve your problem from what has been posted so far?  Even if you have, you might want to post what you've come up with because, as subramaniam.chandrasekar posted, there can be some pretty severe performance problems with these types of things and we can help.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)