我可以获得动态SQL查询来获取输出,如下所示吗? [英] Can I get a dynamic SQL query to get the output as shown as below ?
问题描述
我有一个输入数据,例如,
I have an input data like,
---------------------------------------
M/Y | Total | Con | Est | Keep |
----------------------------------
May-16 | 1000 | 100 | 200 | 500 |
Jun-16 | 5000 | 500 | 1000 | 2000 |
Jul-16 | 10000 | 1000 | 2500 | 5000 |
----------------
我需要输出像,
--------------------
----------------
I need Output like,
--------------------
M/Y | Total | Con | Con(%)| Est | Est(%)| Keep | Keep(%) |
----------------------------------
May-16 | 1000 | 100 | 10% | 200 | 20% | 500 | 50% |
Jun-16 | 5000 | 500 | 10% | 1000 | 20% | 2000 | 40% |
Jul-16 | 10000 | 1000 | 10% | 2500 | 25% | 5000 | 50% |
---------------- -----------
注意:此处Con(%),Est(%),Keep(%)计算在总价值。
EX:Con(%)=(Con / Total)* 100
任何人都可以帮助我。
提前致谢。
我的尝试:
我不明白如何解决这个问题。请帮帮我..!
---------------------------
NOTE : Here the Con(%),Est(%),Keep(%) is calculated on the "Total" value.
EX: Con(%) = (Con/Total)*100
Can anyone help me please.
Thanks in advance.
What I have tried:
I don't understand how to approach this problem. Please help me..!
推荐答案
试试:
Try:
SELECT MY, Total, Con, (Con/Total)*100 AS [Con(%)], Est, ...
或:
Or:
SELECT MY, Total, Con, CONVERT(NVARCHAR(10), (Con/Total)*100) + '%' AS [Con(%)], Est, ...
如果你必须有百分号(我会返回值,而不是我自己的字符串版本)
If you must have the percentage sign (I would return the value, not a string version myself)
>
这篇关于我可以获得动态SQL查询来获取输出,如下所示吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!