IF((SELECT	COUNT(1)
FROM	pal_SurfaceAction
WHERE	actionType = 5) = 0)
BEGIN
INSERT  INTO pal_SurfaceAction
SELECT	5,'Surface Item Code',1
END

IF((SELECT	COUNT(1)
FROM	pal_SurfaceActionType
WHERE	recId = 5) = 0)
BEGIN
INSERT INTO pal_SurfaceActionType
SELECT	'Generate Code', 1
END