there is no row_number () in sql 2000.

Some points....

i think the idea of population a table with necessary values and then doing the update is correct.

From what i have understood

You either update according to ranges or...

Check out the ROW_NUMBER ( ) function.

Coalesce returns first non-null item from multiple expressions.

ex: - select coalesce(null,null,'a',null) will return 'a'.

Isnull can replaces null with a specified value

ex:- select isnull(null,'a') . Note we can specify only one...

check out this post..

http://www.sqlservercentral.com/Forums/Topic571247-338-1.aspx

Yes use the maintenance plan wizard.

Thanks for the info 🙂

In SQL 2005 we need to look at sys.dm_exec_sessions.

Hi

Is the combination of RegistrationNo and the datefield a unique combination. I would think so. So you are better off creating a clustered index on both of these fields together,...

Anybody?

A clustered index on the GPSDATETIME and REGISTRATIONNO seems like the best we can do. Having clustered index increases requires some resources for index maintenance whenver a insert operation/delete operation...

CTE's.

Hi

Dont you have any indexes on the table. Without proper indexes data retrival queries will be slow. You have to be very sure of the queries that hit the table...

Another approach:

Keep another table preferrable a temp table that contains the existing id's and the new value for these ids.

Lookup on this table and then run ur update on...

Hi

From what i have understood from your post and this is the scenario...

lets say id 10 must be 11 and id 11 must be 12

first update id 11 to 12...

Can u tell us exactly what issues/errors you are facing?