quote:

---

Originally posted by dinakar

The functions can only be used in SELECT's. If you need to do an UPDATE, get the data into a table variable or a temp table along with the rank and then do an update on the original table by joining with the table variable/temp table.

---

quote:

---

Originally posted by pootle_flump

What about a CTE?

---

use tempdb
go

create table	#sales 
	(
		productid	int
		, storeid	int
		, dbrowid	int
		, seqid		int
		, linkseqid	int
	)

insert into #sales (productid, storeid, dbrowid)
select	752534, 4, 1
union all 
select	752534, 4, 2
union all 
select	752534, 4, 3
union all 
select	896784, 2, 4
union all 
select	896784, 2, 5
union all 
select	896784, 4, 6
union all 
select	898874, 2, 7
union all 
select	898968, 2, 8
go

with rns
as
(
	select  productid
		, storeid
		, row_number() over     (partition by   productid
							, storeid
					order by        productid
							, storeid) as row_num
	from #sales
)
update	s
set	seqid = row_num
from	#sales as s
inner join
	rns
on	rns.productid = s.productid
	and rns.storeid = s.storeid

select	* 
from	#sales

drop table #sales