INSERT INTO a ( a,b,c )SELECT d,e, @x=@x+1 FROM c WHERE d = 1
declare @x int select @x=max(a) from a --print @xSELECT d,e, 1 as tmp into #b from c where d=1update #b set tmp=@x,@x=@x+1INSERT INTO a ( a,b,c ) SELECT * FROM #bdrop table #b
INSERT INTO a ( a,b,c )SELECT d,e, @x+e FROM c WHERE d = 1
(
a,b,c
)SELECT
d,e, @x=@x+1
FROM
c
WHERE
d = 1
select @x=max(a) from a
--print @xSELECT
d,e, 1 as tmp into #b from c where d=1update #b set tmp=@x,@x=@x+1INSERT INTO a
(
a,b,c
)
SELECT * FROM #bdrop table #b
(
a,b,c
)SELECT
d,e, @x+e
FROM
c
WHERE
d = 1