Summary: Every hour I want to update a table in a SQL Server 7.0 database based on values within the same table and others.<BR><BR>For instance:<BR>Table 1<BR>Column 1 Column 2 Column 3<BR><BR>Table 2<BR>Column 4 Column 5 Column 6<BR><BR>On the hour I want:<BR>Column 1 to INCREASE by Column 4 * Column 5<BR>Column 2 to INCREASE by Column 4&#039;s Percentage of 4 and 5 with a maximum value of Column 6.<BR>Column 3 to INCREASE by Column 5&#039;s Percentage of 4 and 5.<BR><BR>Etc etc etc.<BR><BR>It&#039;s basically just formulas, percentages and maximums assigned from values in other tables. I can fire off timed events - obviously no biggy there - but I&#039;d appreciate some pointers in the easiest, most efficient way to utilize forumulas such as these in the UPDATE.