simple seed

PRINT 'els_hazardCategories BEGIN'

-- important if seed crashed.
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[sp_tmp_insert_Lookup]') AND TYPE IN (N'P', N'PC'))
    DROP PROCEDURE sp_tmp_insert_Lookup
GO

CREATE PROCEDURE sp_tmp_insert_Lookup (@Code nvarchar(64))
AS
BEGIN
    IF NOT EXISTS (SELECT 1 FROM els_hazardCategories WHERE Code = @Code)
        INSERT INTO els_hazardCategories(Code)  VALUES  (@Code)
END
GO

EXEC sp_tmp_insert_Lookup @Code = 'I'
EXEC sp_tmp_insert_Lookup @Code = 'II'
EXEC sp_tmp_insert_Lookup @Code = 'III'

DROP PROCEDURE sp_tmp_insert_Lookup
GO

PRINT 'els_hazardCategories END'