All

I'm working on a webform that populates a textbox by using the max() function from a stored procedure. I need the store procedure to return a value to the @RETURN_VALUE parameter in my dataadapter. How do I do this? The code for the stored procedure is below.

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