for i=201301 to 201312 select a[1]=sum(IntegralValue) from [9002].tb[i]_CardTradingDetails WHERE CardCode= '80000008888' and LEFT(BillNumber,5)<'00090' next i
也可以在 数据库里 建一个视图 vw9002 select * from [9002].tb201301_CardTradingDetails union all select * from [9002].tb201302_CardTradingDetails union all ... union all select * from [9002].tb201404_CardTradingDetails这样,只需要对 vw9002 查询一次即可 记录多了,效率没高多少
select a[1]=sum(IntegralValue) from [9002].tb[i]_CardTradingDetails WHERE CardCode= '80000008888' and LEFT(BillNumber,5)<'00090'
next i
select * from [9002].tb201301_CardTradingDetails
union all
select * from [9002].tb201302_CardTradingDetails
union all
...
union all
select * from [9002].tb201404_CardTradingDetails这样,只需要对 vw9002 查询一次即可
记录多了,效率没高多少