Hi Mike,

Good eyes!

Thanks
Jim




>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