Allocation_Tab 表中
有一个字段为 Number_Of_Container (int 4),如果发现某条记录的该字段的值为n> 1时就将该条记录复制 n-1次，并将新由复制产生的n-1条记录中的 Number_Of_Container字段的内容设为0, 但保留最初记录中 Number_Of_Container
字段中的值不变。
------解决方案--------------------
create table Allocation_Tab(Number_Of_Container int)
insert Allocation_Tab select 3
union all select 1
union all select 4
declare @i int
select @i=max(Number_Of_Container) from Allocation_Tab
set rowcount @i
select ID=identity(int, 1, 1) into #T from syscolumns, sysobjects
set rowcount 0
select Number_Of_Container, Number_Of_Container from Allocation_Tab
union all
select Number_Of_Container, 0 from Allocation_Tab a, #T b
where a.Number_Of_Container> b.ID and a.Number_Of_Container> 1
order by 1, 2
--result
Number_Of_Container Number_Of_Container
------------------- -------------------
1 1
3 0
3 0
3 3
4 0
4 0
4 0
4 4
(8 row(s) affected)