I just want to thank you very much for relieving HOURS of tedium! Even if I have to tweak it a bit (for example, on my updates I add ISNULL(@NewValue,[OldValue]) to the statements so I can do a partial update if I like) I will benefit greatly. I was growing old copying and pasting and typing just to get the procs inplace so I could get to the coding, which is using Entity framework. This really needed doing.:-)

Lisa Z. Morgan