if object_id('v_test') is not null 
drop view v_test
go
create view v_test
as
select 单号,sum(数量) 订单总数 from 你的表
go

select * from v_test;

------解决方案--------------------
select sum(数量) from xxx group by 单号

------解决方案--------------------
select .... into