UPDATE F
				CASE WHEN @model_id	=	1 THEN SET F.forecast_data1	=	T.FORECAST_DATA END,
				CASE WHEN @model_id	=	2 THEN SET F.forecast_data2	=	T.FORECAST_DATA END,
				CASE WHEN @model_id	=	3 THEN SET F.forecast_data3	=	T.FORECAST_DATA END,
				CASE WHEN @model_id	=	4 THEN SET F.forecast_data4	=	T.FORECAST_DATA END,
				CASE WHEN @model_id	=	5 THEN SET F.forecast_data5	=	T.FORECAST_DATA END,
				CASE WHEN @model_id	=	6 THEN SET F.forecast_data6	=	T.FORECAST_DATA END,
				CASE WHEN @model_id	=	7 THEN SET F.forecast_data7	=	T.FORECAST_DATA END
	    FROM #forecast1			F,	
			#TEMP_FORECAST		T
		WHERE F.period_id	=	T.period_id
		AND	  F.period_name	=	F.period_name 	

	UPDATE F
				SET F.forecast_data1	=	CASE WHEN @model_id	=	1 THEN T.FORECAST_DATA ELSE F.forecast_data1 END,
				SET F.forecast_data2	=	CASE WHEN @model_id	=	2 THEN T.FORECAST_DATA ELSE F.forecast_data2 END,
				.
				.
				.

	    FROM #forecast1			F,	
			#TEMP_FORECAST		T
		WHERE F.period_id	=	T.period_id
		AND	  F.period_name	=	F.period_name 	

quote:

---

Originally posted by madhivanan


Like this

	UPDATE F
				SET F.forecast_data1	=	CASE WHEN @model_id	=	1 THEN T.FORECAST_DATA ELSE F.forecast_data1 END,
				SET F.forecast_data2	=	CASE WHEN @model_id	=	2 THEN T.FORECAST_DATA ELSE F.forecast_data2 END,
				.
				.
				.

	    FROM #forecast1			F,	
			#TEMP_FORECAST		T
		WHERE F.period_id	=	T.period_id
		AND	  F.period_name	=	F.period_name 	

Madhivanan

Failing to plan is Planning to fail

---