Untitled

mail@pastecode.io avatar
unknown
plain_text
4 months ago
19 kB
3
Indexable
Hey buddy, can you translate this oracle script for me into postgrescript? 

BEGIN TRANSACTION
DELETE FROM AMOUNT_RANGE_LK
GO
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(34,'VS','PHP',30000000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(34,'VS','USD',600000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(35,'VS','PHP',20000000,29999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(35,'VS','USD',400000,599999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(36,'VS','PHP',15000000,19999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(36,'VS','USD',300000,399999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(37,'VS','PHP',10000000,14999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(37,'VS','USD',200000,299999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(38,'VS','PHP',5000000,9999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(38,'VS','USD',100000,199999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(39,'VS','PHP',2000000,4999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(39,'VS','USD',40000,99999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(40,'VS','PHP',0,1999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(40,'VS','USD',0,39999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')

INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(34,'VR','PHP',30000000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(34,'VR','USD',600000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(35,'VR','PHP',20000000,29999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(35,'VR','USD',400000,599999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(36,'VR','PHP',15000000,19999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(36,'VR','USD',300000,399999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(37,'VR','PHP',10000000,14999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(37,'VR','USD',200000,299999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(38,'VR','PHP',5000000,9999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(38,'VR','USD',100000,199999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(39,'VR','PHP',2000000,4999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(39,'VR','USD',40000,99999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(40,'VR','PHP',0,1999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(40,'VR','USD',0,39999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
/* Traditional */
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(41,'TL','PHP',5000000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(41,'TL','USD',100000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(42,'TL','PHP',3000000,4999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(42,'TL','USD',60000,99999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(43,'TL','PHP',1000000,2999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(43,'TL','USD',20000,59999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(44,'TL','PHP',500000,999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(44,'TL','USD',10000,19999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(45,'TL','PHP',0,499999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(45,'TL','USD',0,9999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(46,'MF','PHP',15000000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(46,'MF','USD',300000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(47,'MF','PHP',10000000,14999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(47,'MF','USD',200000,299999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(48,'MF','PHP',5000000,9999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(48,'MF','USD',100000,199999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(49,'MF','PHP',2000000,4999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(49,'MF','USD',40000,99999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(50,'MF','PHP',0,1999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(50,'MF','USD',0,39999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')

INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(86,'LF','PHP',30000000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(87,'LF','PHP',20000000,29999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(88,'LF','PHP',15000000,19999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(89,'LF','PHP',10000000,14999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(90,'LF','PHP',5000000,9999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(91,'LF','PHP',2000000,4999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(92,'LF','PHP',0,1999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')

INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(86,'LF','USD',600000,99999999999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(87,'LF','USD',400000,599999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(88,'LF','USD',300000,399999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(89,'LF','USD',200000,299999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(90,'LF','USD',100000,199999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(91,'LF','USD',40000,99999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')
INSERT INTO [AMOUNT_RANGE_LK]
           ([RISK_CRITERIA_ID],[INSURANCE_TYPE_CD],[CURRENCY_CD],[RANGE_LOWER_AMT],[RANGE_UPPER_AMT],[CREATED_DTTM],[CREATED_BY],[UPDATED_DTTM],[UPDATED_BY])
VALUES(92,'LF','USD',0,39999.9999,getdate(),'INITIAL DATA - PATCH',getdate(),'INITIAL DATA - PATCH')

COMMIT
GO


My schema for the table is phapipssch21, i want the format 'insert into phapipssch21.amount_range_lk" Thanks!
Leave a Comment