Kald stored proc.

Jeg har følgende proc.

----------------

CREATE Proc sp_GetNextProfileId

    @NextProfileId Int OUTPUT

AS

    DECLARE @Error Int
    SET @Error = 0
   
BEGIN TRANSACTION NextProfileId

    UPDATE SystemVariables SET Val = convert(numeric, Val) + 1 WHERE Name = 'CurrentProfileId'
    SELECT @NextProfileId = convert(numeric, Val) FROM SystemVariables WHERE Name = 'CurrentProfileId'

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

    IF @Error = 0
    BEGIN
        COMMIT TRANSACTION NextProfileId
        /*RETURN @NextProfileId*/
    END
    ELSE
    BEGIN
        ROLLBACK TRANSACTION NextProfileId
        /*RETURN 0*/
    END
GO

-------------

Hvorledes vil I anbefale at jeg kalder den, for at få den output parameter ud?