create table [maomao365]
(A varchar(20),B varchar(30),c varchar(30),qty int)
go
 
 
 
insert into [maomao365]
(A,B,C,qty)values
('A001','A002','A003',5),
('B001','B002','B003',2)
go
 
 
 
select a.A,a.B,a.C,b.number from [maomao365] a 
right join master..spt_values b on b.type='p'
where b.number <=a.qty and b.number >0 
go
truncate table [maomao365]
drop table [maomao365]