以上文字叙述的判断部分请用SQL实现,谢谢帮助select BOOKSTORE_NAME,sum(DEMAND_JAN) as 月总点击量 into #tempToplistDemand
from Build_BookToplist
group by BOOKSTORE_NAME
如果(Build_BookToplist.月总点击量)等于零
执行1语句
否则
跳过1语句,执行下面的语句
from Build_BookToplist
group by BOOKSTORE_NAME
如果(Build_BookToplist.月总点击量)等于零
执行1语句
否则
跳过1语句,执行下面的语句
语句1
语句1
else
下面的语句这样?
if exists(select 1 from #tempToplistDemand where 月总点击量=0)
exec 语句1......