The Jobs table uses JobID as the primary key field. SQL Server 7 has a special ... DECLARE @CatInsert varchar(2000) -- Declare a new variable for the dynamic SQL statement SET @CatInsert = 'INSERT ...