JacekO - Thanks for this but it needed more (see my post about result) 

I did find out though why it worked on some tables and you were right -...

thanks everyone for your help.  i was able to work through it.

apart from the major brain freeze of getting my IDENTITY_INSERT OFF and ONs mixed up (and who hasn't done...