Hello Group,

I am getting an error near Insert. What have I done wrong.

CREATE PROCEDURE cissetschoolyear
(@Schoolyear INT)
AS
/****** Object: Table dbo.schoolyear Script Date: 7/15/2002 2:33:01 PM ******/
if exists (select * from sysobjects where id = object_id('dbo.schoolyear') and sysstat & 0xf = 3)
BEGIN

DELETE Schoolyear

INSERT INTO dbo.Schoolyear (schoolyear)
VALUES(@Schoolyear)
END

ELSE

BEGIN
/****** Object: Table dbo.schoolyear Script Date: 7/15/2002 2:33:01 PM ******/
CREATE TABLE dbo.schoolyear (
schoolyear decimal(5, 0) NOT NULL

INSERT INTO dbo.Schoolyear (schoolyear)
VALUES(@Schoolyear)
END

Thanks
Jim