请问,wyn7,原生查询数据集如何实现参数为空的时候,显示全部数据。
SQL的查询语句如下:
SELECT
[统筹区类别],
[统筹区],
SUM([人次值]) AS [人次值合计],
SUM([总费用]) AS [总费用合计],
SUM([个人现金支付]) AS [个人现金支付合计],
SUM([个人账户支付]) AS [个人账户支付合计],
SUM([共济账户支付]) AS [共济账户支付合计],
SUM([家庭账户支付]) AS [家庭账户支付合计],
SUM([统筹支付]) AS [统筹支付合计],
SUM([大病支付]) AS [大病支付合计],
SUM([医疗救助]) AS [医疗救助合计],
SUM([公务员补助]) AS [公务员补助合计],
SUM([大病补充支付]) AS [大病补充支付合计],
SUM([企业补充支付]) AS [企业补充支付合计],
SUM([医院负担金额]) AS [医院负担金额合计],
SUM([其他支付]) AS [其他支付合计],
SUM([钱包基金]) AS [钱包基金合计],
SUM([总费用]) - SUM([个人现金支付]) - SUM([医院负担金额]) AS [医院总垫付]
FROM
[医保结算明细].[dbo].[医保结算明细]
WHERE
[操作日期] BETWEEN @T1 AND @T2
AND [删除标记] = 0
GROUP BY
[统筹区类别],
[统筹区]
现在需要增加一个参数 P1 用来筛选 统筹区类别,P1为空的时候,显示全部数据。
|