--=================表=============================
Create table #temp_day_stat_ch
(
class varchar(20), --分类(大类)
frequency int, --次数
sumMan int, --总人数
sumMoney money, --总金额
discount money, --折扣金额
income money --实际收入
)
--====================插入统计行================================
INSERT INTO #temp_day_stat_ch
(frequency,summan,sumMoney,discount,income)
(
SELECT SUM(frequency),SUM(SUMMAN),SUM(SUMMONEY),
SUM(DISCOUNT),SUM(INCOME) FROM #temp_day_stat_ch
)
问: 如何更新统计行的分类,比如更新为“合计”
你在网上搜"输出参数"应该可以搜到
INSERT INTO #temp_day_stat_ch
(frequency,summan,sumMoney,discount,income)
(
SELECT '合计', SUM(frequency),SUM(SUMMAN),SUM(SUMMONEY),
SUM(DISCOUNT),SUM(INCOME) FROM #temp_day_stat_ch
)
你是要class这个字段存入'合计'这个字符吧?
INSERT INTO #temp_day_stat_ch
(class,frequency,summan,sumMoney,discount,income)
(
SELECT '合计', SUM(frequency),SUM(SUMMAN),SUM(SUMMONEY),
SUM(DISCOUNT),SUM(INCOME) FROM #temp_day_stat_ch
)