DECLARE @ OldId varchar (50) DECLARE @ CustomerID varchar (50) DECLARE My_Cursor CURSOR -- Define the cursor for (select CustomerID, oldid from Customer where Area = 'bj ') -- locate the desired set and put it in the cursor OPEN My_Cursor; -- OPEN the cursor fetch next from My_Cursor INTO @ CustomerID, @ OldId; -- read the first row of data WHILE @ FETCH_STATUS = 0 begin declare @ OtherPro VARCHAR (500) DECLARE @ StatusID varchar (200) DECLARE @ Userid varchar (200) DECLARE @ FinalUserid varchar (200) SELECT @ OtherPro = OtherPro, @ StatusID = CustomerStatusID, @ Userid = UserID FROM bjsunmis. dbo. customer WHERE CustomerID = @ OldId; SELECT @ FinalUserid = UserID from Users where oldid = @ Userid insert into CustomerotherInfo (CustomerID, OtherPro, CustomerStatusID, UserID) value (@ CustomerID, @ OtherPro, @ StatusID, @ FinalUserid) fetch next from My_Cursor INTO @ CustomerID, @ OldId; -- read the NEXT row of Data ENDCLOSE My_Cursor; -- close the cursor DEALLOCATE My_Cursor; -- release the cursor GO