ALTER PROCEDURE spInsertNewIssue
	(
		@useCaseID int,
		@issue varchar(255),
		@userID smallint=NULL,
		@resolution varchar(255)=NULL,
		@newIssueNumber smallint=1
	)
AS
BEGIN
	SELECT  @newIssueNumber = MAX(issueNumber)+1
	FROM         tblIssues
	WHERE     (useCaseID = @useCaseID)
	GROUP BY useCaseID

	INSERT INTO tblIssues
		(useCaseID, issueNumber, issue, assignedTo, resolution)
	VALUES
		(@useCaseID, @newIssueNumber, @issue, @userID, @resolution)
END
RETURN 

---

spInsertNewIssue 46,'What the hell are we going to do about this?',5,NULL

worked!