我是想让第二个列能自动增加后面的变量,前面的那个是参考一下的而以。
效果就像是用了一个循环一样,后面的数字能自动加,比如auditingassistantbills这个表有四条记录,使用了下面的语句:
declare @a int
set @a=1
select '20050623-01' as '小吕','小林'='2005-' + cast(@a as varchar) from auditingassistantbills
insert Req_subAuditing(AuditingNo,subAuditing,subReqNo)
select '20050636-01','20050626-01-' + b.month,subReqNo
from Req_subBills,
(select '1' as month union all
select '2' as month union all
select '3' as month union all
select '4' as month union all
select '5' as month union all
select '6' as month union all
select '7' as month union all
select '8' as month union all
select '9' as month union all
select '10' as month union all
select '11' as month union all
select '12' as month )b
where subReqNo = '20050622-01-01'
select '20050623-01' as '小吕','小林'='2005-' + b.month
from auditingassistantbills,
(select '1' as month union all
select '2' as month union all
select '3' as month union all
select '4' as month union all
select '5' as month union all
select '6' as month union all
select '7' as month union all
select '8' as month union all
select '9' as month union all
select '10' as month union all
select '11' as month union all
select '12' as month )b