I know this is an old thread but it's still up at the top in Google which is how I found it so thought i'd post my outcome.

I had the...

I think I've sorted now thank you - Just finalising and I'll post details but I'm putting the payments and their row numbers in a second temp table and then...

Thanks Jason, will investigate further...

As an update since my post, the subscriptions do still work after a script has updated them, it only complains when I try to go in...