@pdnethercott

Glad it worked for you!

Yes, I too use a combined "save" procedure in a number of systems (for inserts and updates). You'll easily be able to tweak the code to do this. I did originally have it as generating one "set" procedure but then split it into sperate insert and update ones - so hard to know what an audience will want!

Glad you got some benefit from the article.

Cheers, James