UPDATE dbo.tblCAL_PLAN SET AVAILBLEBED= ( (SELECT AVAILBLEBEDDAYS FROM #TEMP_FA_2003)/ ((SELECT DAYSINMONTH FROM #TEMP_FA_2003) * (SELECT DAYSINMONTH FROM dbo.tblCAL_PLAN WHERE FACILITY='FA_2003') ))
UPDATE t1 SET t1.Field1 = t2.AVAILBLEBEDDAYS/t2.DAYSINMONTH *t1.DAYSINMONTH FROM tblCAL_PLAN AS t1 INNER JOIN #TEMP_FA_2003 AS t2 ON t1.Key = t2.ForeignKey WHERE t1.FACILITY='FA_2003'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)