Something like this:

with basedata as (

select

*, rn = row_number() over (order by part_no)

from dbo.voters

)

update basedata set

rec_num = rn;

Edit: Removed extra order by in CTE

Before doing anything I just want to verify that you are actually using SQL Server 2000 (or older).

Let's make it clickable:

http://borntolearn.mslearn.net/btl/b/weblog/archive/2014/03/10/certification-update-sql-server-2014.aspx

SQLRNNR (3/12/2014)

---

Lynn Pettis (3/12/2014)

---

william.rees.howells (3/12/2014)

---

That is correct. I run it every time I run the query. The query speeds only go back to normal once I drop and recreate the...

william.rees.howells (3/12/2014)

---

That is correct. I run it every time I run the query. The query speeds only go back to normal once I drop and recreate the database, table and...

Info on CLEANBUFFERS

http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(DBCC_DROPCLEANBUFFERS_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(DevLang-TSQL)&rd=true

william.rees.howells (3/12/2014)

---

Hi Sorry, one crucial piece of information that I left out was the fact that I am running DBCC DROPCLEANBUFFERS before I run the query every time. This will...

If any one has some free time this person could use some help. I don't have the free time at the moment.

http://www.sqlservercentral.com/Forums/Topic1549023-391-1.aspx

Care to show us what you have tried to accomplish this task?

vinaya_2690 (3/10/2014)

---

I want the count of orders of a particular table on weekly basis i.e if date given to me is 10\03\2014 then my output should be count of orders...

Again, anything we say is just speculation. We don't have access to your server and the logs. You need to check the all the logs on the server...

It would help if you also posted the DDL for the tables used by the cross tab query in your stored procedure as well as sample data for those tables...

Funny how after 9 years of being on this site some people still need to be spoon fed.

Jack Corbett (3/7/2014)

---

So for those of you who knew I was unemployed. I have an offer on the table. The only problem is that it involves...

First thing you may want to do is to look at the locks that are being taken in your testing. That may help you to answer your question.