
/* Code Fragment 9.6 Change the type of projection 1 to 43. */

INSERT P_TT
SELECT 	PROJECTION_ID, PROJECTION_NAME, 43, SPHEROID_CODE,
	PROJECTION_UOM, ZONE_CODE, GETDATE(), '9999-12-31'
FROM P_TT
WHERE PROJECTION_ID = 1
AND Stop_Date = '9999-12-31'

UPDATE P_TT
SET Stop_Date = GETDATE()
WHERE PROJECTION_ID = 1
AND PROJECTION_TYPE <> 43
AND Stop_Date = '9999-12-31'
