Local Variables In Stored Proc

How do you declare and then SELECT a value for a local variable within
stored procedure, increment the value and then use in an Insert
statement? Thanks

Any sites that explain this syntax for SQL Server 2000? Thanks
hals_left


CREATE PROCEDURE [dbo].[InsertQualUnit]
@QualRef tinyint,
@UnitRef tinyint,
@UnitGroupRef tinyint,

// this needs to be a local var not an output param, how ?
@UnitPosition tinyint Output

AS

// Assign a value to the the variable from a SELECT query, how ?
SELECT @UnitPosition= SELECT MAX(UnitPosition) FROM tblUnitGroup
WHERE QualRef=@QualRef AND UnitRef=@UnitRef AND
UnitGroupRef=@UnitGroupRef

// inc the value
@UnitPosition+=1

// Use the new value in another SQL statement
INSERT INTO tblQualUnits ( QualRef, UnitRef, UnitGroupRef ,
UnitPosition )
VALUES ( @QualRef, @UnitRef, @UnitGroupRef , @UnitPosition)
GO