Too damn lazy to this of SQl code at this time... anyone switched on enough to help??

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

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

That should do it:)

Quote:

---

Originally posted by Nit
/me goes back to sleep
NIt

---

[Old fart mode]I dunno, students these days. When I was at Uni....... [/Old fart mode];)