quote:

---

Originally posted by helixpoint

I am getting the following error if there are no records in the table. The 'project_priority' field in an int

Cannot insert the value NULL into column 'project_priority', table 'nsvrc.dbo.Projects'; column does not allow nulls. INSERT fails.

The statement has been terminated.



ALTER PROCEDURE dbo.InsertProject

(
@txtTopic AS VARCHAR(100),
@userid AS int,
@maxID as int OUTPUT
)
AS
SET NOCOUNT ON
INSERT INTO Projects (project_priority, project_Desc, userID, lastModified)
SELECT IsNull(MAX(project_priority),0)+1, @txtTopic,@userid, GETDATE() FROM Projects
SET @maxID = Scope_Identity()
SET NOCOUNT OFF
RETURN

---