Below is my attempt - wrong!!

alter PROCEDURE sp_GetCounter(@ccnt int) as

declare @counter int

set @counter = @counter+@ccnt

return @ccnt

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

Just a thought, why r u returning @ccnt when ur incrementing @counter in ur Proc.?