27,580
社区成员
发帖
与我相关
我的任务
分享
create table test(A int, B int, C varchar(20), D varchar(20))
go
insert into test values
(100,10,'AAX160002983','AAX160002992'),
(200, 2,'AAX160006966','AAX160006967')
go
select t.A, 'AAX' + ltrim(REPLACE(t.C,'AAX','') + s.number) AAX
from test t , master..spt_values s
where t.B > s.number and s.type ='p'
go
drop table test
go
(2 行受影响)
A AAX
----------- ---------------
100 AAX160002983
100 AAX160002984
100 AAX160002985
100 AAX160002986
100 AAX160002987
100 AAX160002988
100 AAX160002989
100 AAX160002990
100 AAX160002991
100 AAX160002992
200 AAX160006966
200 AAX160006967
(12 行受影响)