• Hi,

    I think one problem is you forgot to say 'set'...

    For example, this:

    BEGIN

    @statusID = 3

    END

    ...should be this:

    BEGIN

    SET @statusID = 3

    END