use Northwind

CREATE TABLE Categories2
       (
	CategoryID int NOT NULL ,
	CategoryName  varchar( 15 )
       )



insert inTo Categories2
Select CategoryID,
       CategoryName 
  from Categories


Declare @CategoryID int,
 	@CategoryName varchar( 15 )

DECLARE cursor_name CURSOR 
FOR  Select CategoryID,CategoryName 
       from Categories2
      where CategoryID >  0 

OPEN cursor_name
FETCH NEXT FROM cursor_name into @CategoryID,@CategoryName
WHILE (@@fetch_status <> - 1 )
BEGIN
if @CategoryID >  0  
	begin
	update Categories2 set CategoryID =  0  where CategoryID = @CategoryID
	end

FETCH NEXT FROM cursor_name into @CategoryID,@CategoryName
END
CLOSE cursor_name
DEALLOCATE cursor_name

update Table
     set Table.Column = newtable.column1
   from  newTable
where Table.ColumnID = NewTable.ColumnID2