如何使用SQL Server功能或存储过程与报告 [英] How to Use SQL Server Function or Stored Procedure With Reporting

问题描述

我在SQL Server中有两个表。一个表名是tsim_hasta_say：

I have a two table in SQL Server.One Table Name is tsim_hasta_say:

--group--HospitalCode--tsimHastaSay--Donem--tsimToplamHasta--id
  1.Grup    2784        8433         51       268391       3288
  2.Grup    676        7434          51       197388       3289
  1.Grup    4527        6563         51       158885       3290

我们还有一张SMHASTANEDONEMVERILERI_Y表

And also we have a SMHASTANEDONEMVERILERI_Y table

--HospitalCode -- Donem -- Bagil -- Vaka--tigFrekans

   2784           51        154.23   1.23  300
   676            51        165.12   1.05  500 
   4527           51        123.32   1.32  400 

I想用两张桌来计算。



这里的公式：

I want to calculate to paying using two tables.

Here its formulas:

A: indicates tsim_hasta_say.tsimHastaSay column
B: indicates SMHASTANEDONEMVERILERI_Y.tigFrekans column
C: indicates SMHASTANEDONEMVERILERI_Y.Bagil /SUM(SMHASTANEDONEMVERILERI_Y.Bagil) 
D: indicates SMHASTANEDONEMVERILERI_Y.Vaka /SUM(SMHASTANEDONEMVERILERI_Y.Vaka)

我想使用此指示计算如下所示：

I want to calculate using this indicates shown in below:

STD_u=(A/B)
STD_e=(C+D)

如何使用SQL SERVER标准程序或函数计算？



谢谢

How Can I calculate this using SQL SERVER Strored Procedure or Function?

Thanks

推荐答案

试试这个：

Try this:

SELECT A/B AS STD_u, (C1/C2)+(D1/D2) AS STD_e
FROM (
    SELECT ths.tsimHastaSay AS A, shd.tigFrekans AS B, shd.Bagil AS C1, (SELECT SUM(Bagil) FROM SMHASTANEDONEMVERILERI_Y) AS C2,
        shd.Vaka AS D1, (SELECT SUM(Vaka) FROM SMHASTANEDONEMVERILERI_Y) AS D2
    FROM tsimHastaSay AS ths INNER JOIN SMHASTANEDONEMVERILERI_Y AS shd ON ths.HospitalCode= shd.HospitalCode
) AS DT

这篇关于如何使用SQL Server功能或存储过程与报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！