January 19, 2012 at 8:34 pm
All,
I have 2 tables Provider_Status_Meta_Data with columns (Code, Display_Status, Description, ...., .....) and Provider_Address_Validation with columns(Code, Display_Status, .........). There is information stored in Provider_Status_Meta_Data Table. When Code entered in Provider_Address_Validation table that code column should compare with code column of Provider_Status_Meta_Data and Display_Status of Provider_Status_Meta_Data should be updated automitically in Provider_Address_Validation table.
Your help is highly appreciated.
Thanks
January 20, 2012 at 8:19 am
Sounds like you need to investigate triggers. It is very hard to understand exactly what you are trying to accomplish but it sounds like an update trigger on your validation table is what you are looking for.
_______________________________________________________________
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/
January 24, 2012 at 5:43 am
Is the code being updated from UI then you go for updating the values through SP or use triggers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply