Stored Procedure That Fetch Each Row Of A Table And Update Rows In Another Table

I am working with the following two tables:



Category(NewID,OldID)

Link(CategoryID,BusinessID)



All fields are of Integer Type.



I need to write a stored procedure in sql 2000 which works as follows:



Select all the NewID and OldID from the Category Table

(SELECT NewID,OldID FROM Category)



Then for each rows fetched from last query, execute a update query in the Link table.



For Example,



Let @NID be the NewID for each rows and @OID be the OldID for each rows.

Then the query for each row should be..



UPDATE Link SET CategoryID=@CID WHERE CategoryID=@OID



Please help me with the code.



Thanks,

anisysnet