Sean, do you mean same code but instead of calling sp just fore trigger when the value changes?
Please bear with me as I am a newbie.
This will explain what a trigger is and how they operate. http://msdn.microsoft.com/en-us/library/ms189799.aspx
Just make sure that if you do use a trigger that it can handle multiple row updates.
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 Moden's splitter
.Cross Tabs and Pivots, Part 1 – Converting Rows to Columns Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs Understanding and Using APPLY (Part 1)Understanding and Using APPLY (Part 2)