alan_lynch (3/6/2013)

---

Hi Brad.

The software_name_raw on the RefTable is the Primary Key

Does that help

alan_lynch (3/6/2013)

---

Sorry Lynn

The BigTable.software_name_raw contains

SOFTWARE_NAME_RAW
Microsoft Office 2003 Professional Edition, Office 2003 Professional
Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional
Microsoft 2003 Office Professional, Office 2003 Professional

and the RefTable contains a further column

SOFTWARE_NAME_RAW,SOFTWARE_NAME_AMENDED

Microsoft Office 2003 Professional Edition, Office 2003 Professional
Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional
Microsoft 2003 Office Professional, Office 2003 Professional

So if the two columns match then update the BigTable with the software_name_amended column from the RefTable

If there is no initial match then I want to insert into the RefTable a new found reference

EG Microsoft 2003 PRO, 'Needs Updating'

Hope this helps

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