Hi Livingston,

No, the actual tables are different but the other columns are not significant. The essence of the problem is how to split the Receipt table row based on the receipt amount as per the "MemberPremiumDet" table's premiumAmt.

This is a real difficult task to do without CURSORS/LOOPS.

I am wondering whether this can be accomplished without CURSORS or LOOPS.

These kind of transactions are usual in Banking and Insurance applications.

Anyway would datetime columns in these type of scenario help a lot?

Regards