如何在存储过程中进行计算 [英] how to do calculation in stored procedure

问题描述

HI，



我要进行一次计算。以下是我的代码。我想在临时表中选择一些数据，然后对所有值intblCAL_PLAN进行计算。并将其保存到同一个表。我怎么能这样做？

这里DAYSINMONTH有12个值（30,31 ....）我对这12个值进行计算并保存。

有人帮我这么做吗？

 更新 dbo.tblCAL_PLAN  SET  AVAILBLEBED = 
（
（ SELECT  AVAILBLEBEDDAYS  FROM  #TEMP_FA_2003）/ 
（（ SELECT  DAYSINMONTH < span class =code-keyword> FROM  #TEMP_FA_2003）* 
（ SELECT  DAYSINMONTH  FROM  dbo.tblCAL_PLAN  WHERE  FACILITY = '  FA_2003 '）
））

解决方案

要使用SELECT语句更新表，请尝试：

 更新 t1  SET  t1.Field1 = t2.AVAILBLEBEDDAYS /t2.DAYSINMONTH * t1.DAYSINMONTH 
  FROM  tblCAL_PLAN  AS  t1  INNER   JOIN  #TEMP_FA_2003  AS  t2  ON  t1。键 = t2.ForeignKey 
  WHERE  t1.FACILITY = '  FA_2003'  

HI,

I am going to one calculation. Below are my code. I want to select some data in temp table and i do that calculation for all the values intblCAL_PLAN. and save that to same table. how can i do this?
Here DAYSINMONTH has 12 values(30,31....) I do the calculation for this 12 values and save withinit.
Anyone help me to do this?

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')
  ))

解决方案

To update table with SELECT statement, try this:

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'

这篇关于如何在存储过程中进行计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！