300分解一问题,解决的话在给200分
lllqe 2005-02-07 10:39:30 CREATE TABLE #TMP(JT VARCHAR(20) not null,bph varchar(10) not null,Sph Varchar(50) Null,quantity decimal(18,4) Null)
Insert Into #tmp
Select 'A','001','A001',20
Union all
Select 'A','001','A002',20
Union all
Select 'A','002','A003',23
Union All
Select 'B','001','A002',25
Union All
Select 'B','002','A002',25
Union All
Select 'C','001','A003',26
要求输出
JT bph Sph1 Sph2 quantity
A 001-002 A001 A002 43
B 001-002 A001 50
C 001 A003 26