Basic SQL cursor usage

Create procedure [dbo]. [pro_CURSOR]
AS
BEGIN

-- Declare a cursor
DECLARE MyCURSOR CURSOR
SELECT userid, depid FROM users

-- Open the cursor
Open MyCURSOR

-- Declare two variables
Declare @ userid varchar (50)
Declare @ depid varchar (50)

-- Move cyclically
Fetch next from MyCURSOR into @ userid, @ depid
While (@ fetch_status = 0)
Begin
Update users set description = (select dep_des from department where depid = @ depid)
Where userid = @ userid
Fetch next from MyCURSOR into @ userid, @ depid
End

Close MyCURSOR
Deallocate MyCURSOR

END