My company is using a third party software designed by other private company. there is a point where there is data redundacny on our tables and it requires me to do the data cleaning. i thought it would be better to fix the incorrect field with the procedure with those filed require a common value. i decided to write a procedure to update those files where there is an mispelled of words. and i have to run that query everyday, i was wondering if the Trigger would help here, if maybe i put my Procedure inside the trigger and when ever a user enters wrong info , it can be triggered?
Help i dont know what option to do am using SQL 2005[IMG]http://www.codeproject.com/script/images/smiley_confused.gif[/IMG]
Vuyiswa