从满足条件的表A执行求和并保存到表B. [英] Perform sum from table A where a condition is met and save to Table B
问题描述
你好,美好的一天,
我是一名新手。我在C#中遇到了这个挑战,如果有人能帮助我,我将不胜感激。我有三个表格如下所述;
表A
VehN,Dst,TrpM
表B < br $>
VehN
表c
VehN,Tot_Dst
表A数据
VehN Dst TrpM
UYO123CDF,2000,OCT
PHC456ABU,150,OCT
ERT678SER,250,OCT
ERT678SER,1500,OCT
UYO123CDF,501,OCT
KUU8376G,83155,SEP
KUU8376G,1500,OCT
LAG123EKY,3100,OCT
KUU8376G,601,OCT
PHC456ABU,500,OCT >
PHC456ABU,801,OCT
表B数据
VehN
UYO123CDF >
PHC456ABU
ERT678SER
KUU8376G
LAG123EKY
我希望将TABLE C更新为sum(table-A.Dst),其中表-B中的第一个数据=表-A.VehN,其中Table-A.TrpM ='OCT'这应该继续直到Table-B文件结尾。
表C现在看起来像这样
VehN,Tot_Dst
UYO123CDF,2,501
PHC456ABU,1,451
ERT678SER,1,750
KUU8376G,2,101
LAG123EKY,3,100 >
我将需要ac#code和SQL命令,这将使我能够实现上述描述。
Olabode
Hello and Good day,
I am a new beginner. I have this challenge in C# and would appreciate if anyone can help me out. I have three tables as described belo;
TABLE A
VehN, Dst, TrpM
TABLE B
VehN
TABLE c
VehN, Tot_Dst
TABLE A DATA
VehN Dst TrpM
UYO123CDF, 2000, OCT
PHC456ABU, 150, OCT
ERT678SER, 250, OCT
ERT678SER, 1500, OCT
UYO123CDF, 501, OCT
KUU8376G, 83155, SEP
KUU8376G, 1500, OCT
LAG123EKY, 3100, OCT
KUU8376G, 601, OCT
PHC456ABU, 500, OCT
PHC456ABU, 801, OCT
TABLE B DATA
VehN
UYO123CDF
PHC456ABU
ERT678SER
KUU8376G
LAG123EKY
I want TABLE C to be updated as sum(table-A.Dst) where first data in Table-B = Table-A.VehN and where Table-A.TrpM = 'OCT' This should continue untill Table-B end of file.
Table C will now look like this
VehN, Tot_Dst
UYO123CDF, 2,501
PHC456ABU, 1,451
ERT678SER, 1,750
KUU8376G, 2,101
LAG123EKY, 3,100
I will need a c# code and SQL command that will enable me achieve what I described above.
Olabode
推荐答案
这样的东西?
Something like this?
UPDATE TableC c
set Tot_Dst =
(
SELECT SUM(TableA.Dst) FROM TableA a WHERE a.TrpM="OCT" AND a.VehN = c.VehN
)
where c.VehN in (SELECT VehN from TableB)
这是T-SQL的一部分。对于C#部分,它取决于您需要从代码传递到T-SQL。如果需要,您可以传递月份甚至TableB,但是您需要将其包装在存储的程序中。
This is for T-SQL part. For C# part it depends what do you need to pass from code to T-SQL. You can pass month or even TableB if necessary, but than you need to wrap this in a stored proceudre.
这篇关于从满足条件的表A执行求和并保存到表B.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!