CREATE PROCEDURE [dbo].[UMG_EXP_RECOVERY]
AS

SET NOCOUNT ON
DECLARE @strCharID CHAR(21)
DECLARE @nExp   INT
DECLARE job1 CURSOR FOR

SELECT strUserID, nExp FROM EXP_RECOVERY

OPEN job1
FETCH NEXT FROM job1
INTO @strCharID, @nExp
WHILE @@fetch_status = 0
BEGIN
    DECLARE @nOldExp INT

    SELECT @nOldExp = EXP FROM [USERDATA] WHERE [strUserID] = @strCharID
    IF @nOldExp > 0
    BEGIN
        UPDATE USERDATA SET EXP = @nOldExp + @nExp WHERE [strUserID] = @strCharID
    END

    FETCH NEXT FROM job1
    INTO @strCharID, @nExp
END
CLOSE job1
DEALLOCATE job1
SET NOCOUNT OFF

DELETE FROM EXP_RECOVERY