Also... if anyone wants to point me in the direction for examples, tutorials or resources, I would like to evolve this SP into a very generic object and feed it the table names, fields, values to do ANY (most) insert(s) in the app. I understand I am going to have to use something called vectoring to define those parameters applicatin wide. I originally thoght I could could simply declare them all in a single constants file. I am entering the T-SQL/SP world with a limited understanding of syntax and contruct obatined primarily via ASP and ADO.
Thanks Folks - Brad
I have refrenced this post as source for the SCOPE_IDENTITY() idea: