You're missing a closing paren on the CREATE TABLE statement.

-Mike

>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