社区问的人太多了,保存一个备用
--
建立测试环境
set nocount on
create table test(model varchar ( 20 ),date int ,qty int )
insert into test select ' a ' , ' 8 ' , ' 10 '
insert into test select ' a ' , ' 10 ' , ' 50 '
insert into test select ' b ' , ' 8
set nocount on
create table test(model varchar ( 20 ),date int ,qty int )
insert into test select ' a ' , ' 8 ' , ' 10 '
insert into test select ' a ' , ' 10 ' , ' 50 '
insert into test select ' b ' , ' 8