I got a table, lets call it CALUsers.. in it I got two fields, Username (unique) and CALLevel.


In my sp I want to update the level by one for a unique user...a bit like this:

CREATE PROCEDURE [sp_levelup]
@SYSUsername as char(50)
AS
Update (CALLevel += 1) from CALUsers
where
@SYSUsername = Username


only I'm in C++ mode this morning and have forgotten my updates and inserts mantra...

anyone awake enough to help?


Nit