Stored procedure for inserting a new activity

createActivityWithTitle.sql

CREATE PROCEDURE [ppdbuser].[createActivityWithTitle] @project_id integer, @creator_id integer, @title varchar(255)
AS
  INSERT INTO ppActivities (project_id, creator_id, title, local_id) 
  VALUES (@project_id, @creator_id, @title, (SELECT ISNULL(MAX(local_id)+1,1) FROM ppActivities WHERE project_id = @project_id))
  SELECT * FROM ppActivities WHERE id = scope_identity()