62,046
社区成员
发帖
与我相关
我的任务
分享
declare @tempSql varchar(4000);
set @tempSql =' select used_amount,month_1,month_2,month_3,month_4,
month_5,month_6,month_7,month_8,month_9,month_10,month_11,month_12
from #temp where 1=1 ';
if(@city <>'' and @city <>'0')
set @tempSql += ' and city in '+@city+'';