Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using a trigger to calculate an average

Author  Topic 

taylo
Yak Posting Veteran

82 Posts

Posted - 2000-11-18 : 21:43:34
I wrote a trigger (my first one) to calculate averages on a field in my database. The syntax all went well but the trigger did not work peoperly. I could not INSERT in to my database and the fields kept returning NULL.

This trigger should automatically do the average upon and INSERT, UPDATE, OR DELETE correct? That is the way it is written anyway.

Thanks,

Rob

   

- Advertisement -