将Excel代码转换为TSQL [英] Convert Excel code to TSQL

问题描述

我在Excel中有SUMIF 

= SUMIFS（[需求] ]，[IPlName]，[@ IPName]，[CID]，[@ CID]，[YearMonth]，"< ="& [@ YearMonth]）

< span style ="color：＃242729; font-family：Arial，'Helvetica Neue'，Helvetica，sans-serif; font-size：15px">但是，我不知道如何将此Excel公式转换为SQL查询如果有人能帮助我根据上面的公式编写正确的SQL查询语句
，我将不胜感激。

谢谢事先。

解决方案

你能检查一下吗？

https://stackoverflow.com/questions/17294973/how-to-write-a-sql-query-implementing-excel-sumifs-功能

I have SUMIFs in excel 

=SUMIFS([Demand],[IPlName],[@IPName],[CID],[@CID],[YearMonth],"<="&[@YearMonth])

However, I don't know how to convert this Excel formula to a SQL query and I would appreciate if anyone can help me in writing the correct SQL query statement based on the above formula.

Thanks in advance.

解决方案

Can you check this?

https://stackoverflow.com/questions/17294973/how-to-write-a-sql-query-implementing-excel-sumifs-function

这篇关于将Excel代码转换为TSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！