Please post SQL 2000 questions in the SQL 2000 forums in the future.
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Shouldn't be any need for a cursor here. Of course, without seeing what you want to update and to what, it's hard to say for sure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability