日期:2014-05-16 浏览次数:20466 次
select 1 [id],200 [ty],10 [num] into [#t]
union select 1 [id],201 [t],11 [num]
union select 1 [id],202 [t],80 [num]
union select 1 [id],203 [t],20 [num]
union select 2 [id],201 [t],21 [num]
union select 2 [id],203 [t],18 [num]
union select 3 [id],201 [t],20 [num]
union select 3 [id],202 [t],10 [num]