alan_lynch (3/6/2013)

---

Ok Lynn if thats what you want to do and move on and help someone else then thats fine.

I am new to SqlServer so I dont know how to do the insert statement properly, thats why I asked this in my initial enquiry asking if data can be inserted into the reference table if it does not exist during my update.

I will await Brad's reply he seems to know what I mean