در query دوم که بعد از union all اومده 1977 سطر آخر رو بدست بیاره و اعداد مورد نظر رو لحاظ کن، البته فراموش نکن که 1977 سطر آخر در query اول انتخاب نشن.
declare @Numbers table(i int)
insert into @Numbers
select top 985977 row_number()over(order by (select 1)) from sys.columns a,sys.columns b, sys.columns c
;with YT as
(
select *, ROW_NUMBER() OVER(ORDER BY [dav])AS ROWNUM
from [MakeRadifMajazi].[dbo].[rdf]
)
UPDATE YT
SET YT.r2 = C.radif
FROM YT
INNER JOIN( select i,case when i%2000 = 0 then i-2000 else (2000*(i/2000)) end
+case(i%250)when 0 then 249 else(i%250-1)end *8+((rnk+249)/250) as radif
from (
select i, row_number() over(partition by (i+(8*250)-1)/(8*250) order by i) rnk
from @NUMBERS
WHERE i <= 985977
)d
union all
select i,case when i%2000 = 0 then i-2000 else (2000*(i/2000)) end
+case(i%250)when 0 then 249 else(i%250-1)end *8+((rnk+249)/250) as radif
from (
select i, row_number() over(partition by (i+(8*250)-1)/(8*250) order by i) rnk
from @NUMBERS
WHERE i <= 985977
)d
)c ON
[YT].ROWNUM = c.i
پاسخ با نقل قول