34,576
社区成员
发帖
与我相关
我的任务
分享
/*
*************************************
* T-MAC 小编 *
* -->努力成长中 *
* -->梦想DBA *
*************************************
*/
if OBJECT_ID('tb') is not null
drop table tb
go
create table tb (id int, PolicyNo varchar(10) , PN int)
insert tb select
1, '543543545', 2 union select
2, 'rewrwe543', 4 union select
3, '45434r43' , 1 union select
4, '4543r3' , 2 union select
5, 'ewwqewq' , 5
go
select id=IDENTITY(int,1,1),t.PolicyNo,TermNo=s.number
into b
from tb t join master..spt_values s
on s.number between 1 and t.PN
where s.type='P'
go
select * from b
/*
id PolicyNo TermNo
----------- ---------- -----------
1 543543545 1
2 543543545 2
3 rewrwe543 1
4 rewrwe543 2
5 rewrwe543 3
6 rewrwe543 4
7 45434r43 1
8 4543r3 1
9 4543r3 2
10 ewwqewq 1
11 ewwqewq 2
12 ewwqewq 3
13 ewwqewq 4
14 ewwqewq 5*/