INSERT INTO VS4TProjectType (TPjtCode, TPjtName, TPjtName2, TPjtFlag1, TPjtFlag2, TPjtFlag3) VALUES ('INTERNAL', 'Internal Project', NULL, 1, 0, 0)
GO
INSERT INTO VS4TProjectType (TPjtCode, TPjtName, TPjtName2, TPjtFlag1, TPjtFlag2, TPjtFlag3) VALUES ('PROJECTA', 'BOI PROJECT 0001/2550', NULL, 1, 0, 0)
GO
INSERT INTO VS4TProjectType (TPjtCode, TPjtName, TPjtName2, TPjtFlag1, TPjtFlag2, TPjtFlag3) VALUES ('PROJECTB', 'BOI PROJECT 0002/2550', NULL, 1, 0, 0)
GO
INSERT INTO VS4TProjectType (TPjtCode, TPjtName, TPjtName2, TPjtFlag1, TPjtFlag2, TPjtFlag3) VALUES ('PUBLIC', 'Public Project', NULL, 1, 0, 0)
GO
UPDATE VS4TProject SET TPrjTPjtCode=TPrjCode
GO
DELETE FROM VS4TProjectType WHERE TPjtCode='ASSET-MA'
GO
DELETE FROM VS4TProjectType WHERE TPjtCode='BUILDING'
GO
DELETE FROM VS4TProjectType WHERE TPjtCode='TURNKEY'
GO
DELETE FROM VS4TProjectType WHERE TPjtCode='NT'
GO