ALTER PROCEDURE dbo.GetMaxTaskNo ( @project_id int, @MaxTaskNo int OUTPUT ) AS SELECT @MaxTaskNo = max(isNull(task_no,0)) FROM task_header WHERE project_id = @project_id RETURN~~Bonnie
>ALTER PROCEDURE dbo.GetMaxTaskNo >( > @project_id int >) >AS >SELECT max(isNull(task_no,0)) AS "MaxTaskNo" > FROM task_header > WHERE project_id = @project_id > > RETURN >