Thank you Eugene. I think I briefly looked at a solution like this, but then focused on @@identity and Scope_Identity, which doesn't appear to work for bulk input. ...

I finally got it to work. I ended up using R.P. Rozema's solution, but I learned a lot more, and greatly appreciate everybodys comments.

Some things I got out of...

First of all, let me apologize to Celko...I responded before I did my breathing exercises. Althought I was not fond of the "presentation", I do appreciate your efforts, and...

What is DLL? Read what section at the start of Forum? ...

Thank you. I will have to test it Monday.

Not familiar with the "with" statement...will have to research that one.

again, thanks, and will let you know.

Thank you. Went and figured out what a cte was and how to used it, and now the query works perfectly. Thank you.