jancas08 (2/27/2013)
Now, my rule is that: basically where ever there is an update you update the the table with the values. You determine what table to update by the error message.If the error message is ED* then you update the education table
If the error message is HH* then you update the HH_ALL table
If the error message is HL* then you update the HL table
If the error message is O14* then you update the FOURTEEN_ALL table
The same rules apply when you delete and insert into a table.
I assume you mean ERRORMESSAGE from ERROR_FILE_OW4_4? There is no data in this table. Keep in mind I don't know your system, I am not familiar with your project and I can't see over your shoulder.
As a side note, your tables suffer greatly from a lack of normalization and there are no indexes, keys or referential integrity.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/