Inserting a cloum in a stored procedure

[iHavAQuestion]

I have stored procedure
In @var1/Col1 I need to insert, the max(col) from another table in the
same database.


Create Stored Procedure Name
(
@Var1
@Var2
@Var3
)
Inseret into table1
(
Col1
col2
col3
)
Values
(
@Var1
@Var2
@Var3
)

 

[Jeff Dillon]

Select @var1 = max(col) from othertable