紧急求助！ 谢谢了！

[linzhisong]

我现在有个表
id name num
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5

现在有一个变量@i
如果@i=1
id name num
1 1 2
2 2 3
3 3 4
4 4 5
5 5
如果@i=2
id name num
1 1 3
2 2 4
3 3 5
4 4
5 5

怎么实现？

[voyager]

说清楚一点？

[pengdali]

create table #a(id int,name int,num int)
insert #a values(1, 1, 1)
insert #a values(2, 2 ,2)
insert #a values(3 , 3 , 3)
insert #a values(4 , 4 , 4)
insert #a values(5 , 5, 5)

declare @i int

set @i=2


select id,name,case when num+@i<=5 then num+@i end num from #a

go
drop table #a

[stone_lin]

create function funGetValue(@id int,@i int)
returns int
as
declare @v int
Select @v=num from table where id=@id + @i
return @v


select id,name,funGetValue(id,@i) from table

[linzhisong]

就是等1的时候 把后一笔的num值给前一笔。

以此类推！

[pengdali]

--如果你要修改：

create table #a(id int,name int,num int)
insert #a values(1, 1, 1)
insert #a values(2, 2 ,2)
insert #a values(3 , 3 , 3)
insert #a values(4 , 4 , 4)
insert #a values(5 , 5, 5)

declare @i int

set @i=2

update #a set num=case when num+@i<=5 then num+@i end

select * from #a
go
drop table #a

[black_snail]

select a.id,a.name ,b.num
from t1 a,t1 b
where (a.id + @i) = b.id(+)

[linzhisong]

谢谢！ 晕，我给的数据怎么就这么巧合！

[linzhisong]

id name num

asd 34 3434
3sd1 234 grr
fs 343 tt
sd 343 66
asd 343 fff

[SophiaWang]

select id,name,case when (num+@i)>5 then null else num+@i end num from tablename

[linzhisong]

谢谢！ 不好意思，我数据给错了 !

[joygxd]

select a.id,a.name,(case when a.newid=b.newid then (select a.num from a where a.newid=a.newid+1) end )as num
from (select identity(int,1,1) newid,* into #temp from table) a,(select identity(int,1,1) newid,* into #temp from table) b
where a.id=b.id

[SophiaWang]

alter table sub add idd int identity
go

declare @i int
set @i=1

select id,name,(
select num from sub b
where a.idd = b.idd - @i) num from sub a

alter table sub drop column idd

[linzhisong]

谢谢！

揭帖！

[lizongqi]

到此一游