I cannot merge the columns because the table is being used for import in another application. 

The application will reject the table if it is not in this format.

Here is the trigger code:

CREATE Trigger RollingDB ON tbltemp

AFTER insert

AS

EXECUTE dbo.UpdateTempNulls

EXECUTE dbo.rollingTable

EXECUTE dbo.InsertIntoForecast

EXECUTE dbo.UpdateForecast

Here is the code for the stored procedures:

Create Procedure UpdateTempNulls

AS

UPDATE tblTemp

SET hour1 = (hour2+hour24)/2

WHERE hour1 IS NULL

Create...

The reason the trigger timesout is because of an stored procedure that i'm running.

Here is the code:

UPDATE tblForecastTemp SET hour1 = (SELECT tbltemp.hour1 FROM tbltemp

WHERE tblForecastTemp.[year] = tbltemp.[year] AND tblForecastTemp.[month]

=...