Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
An update which does not finish
Message
 
 
To
20/04/2015 14:15:54
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01618796
Message ID:
01618805
Views:
30
>>Michel, Sorry I am not providing any help with your question, but I would change the whole approach, after all why do you update fields that can be calculated when required? You can easily create a view with this information without the massive updates with values that are derived from other tables/fields.
>
>This is a process to fix values in an existing table.
>
>The live maintenance of those fields is done whenever a record is being updated.

Do you mean in a trigger?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform