Ret min sp

CREATE Proc sp_GetNextMemberNumber

    @CurrMemberNumber Int OUTPUT

AS

    DECLARE @Error Int
    SET @Error = 0
   
    DECLARE @NewMemberNumber int

BEGIN TRANSACTION NextMemberNumber

    SET @CurrMemberNumber = SELECT convert(numeric(9, Val) FROM SystemVariables WHERE Name = 'NextProfileId'

    SET @NewMemberNumber = @CurrMemberNumber + 1

    IF @@Error <> 0
    BEGIN
        SET @Error = 1
    END

    UPDATE SystemVariables SET Val = @NewMemberNumber WHERE Name = 'NextProfileId'

    IF @@Error <> 0 OR @@ROWCOUNT <> 1
    BEGIN
        SET @Error = 1
    END

    IF @Error = 0
    BEGIN
        COMMIT TRANSACTION NextMemberNumber
    END
    ELSE
    BEGIN
        ROLLBACK TRANSACTION NextMemberNumber
        SET @NewMemberNumber = 0
    END
GO

"Incorrect syntax near SELECT"

Er der en der kan afhjælpe mig?

Thanx!