Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
1.2 kB
2
Indexable
Never
UPDATE bsi.mrms.nsfr_paramSetComponents 
SET factorWithoutTimeframe = NULL , factorSixMonthsDown = NULL, factorSixMonthsUp = NULL
WHERE CONVERT(varchar(max), name) = 'Aset lainnya' AND number = '5';

UPDATE bsi.mrms.nsfr_masterParamSetComponents  
SET factorWithoutTimeframe = NULL , factorSixMonthsDown = NULL, factorSixMonthsUp = NULL
WHERE CONVERT(varchar(max), name) = 'Aset lainnya' AND number = '5';

update  bsi.mrms.nsfr_masterConfiguration set value = '0-05-4-110,0-05-4-120,0-05-4-210,0-05-4-220,0-05-4-221,0-99-9-981,0-99-9-984,0-15-1-100,0-15-1-101,0-15-1-102,0-15-1-105,0-15-1-106,0-15-1-107,0-15-1-199,0-99-9-977,0-99-9-978,0-99-9-979,0-99-9-980,0-99-9-985,0-99-9-986,0-99-9-987,0-99-9-989'    where code = 'LTTR_OF_CRDT_COA'; 





--------------------------------------


DELETE FROM bsi.oprisk.rcsa_rejectReason
DELETE FROM bsi.oprisk.rcsa_riskLibraryBranchEvaluation
DELETE FROM bsi.oprisk.rcsa_riskLibraryBranchItem
DELETE FROM bsi.oprisk.rcsa_riskLibraryBranch
DELETE FROM bsi.oprisk.rcsa_riskLibraryMasterItem
DELETE FROM bsi.oprisk.rcsa_riskLibraryMaster
DELETE FROM bsi.oprisk.rcsa_riskLibraryEvaluation
DELETE FROM bsi.oprisk.rcsa_riskLibraryItem
DELETE FROM bsi.oprisk.rcsa_riskLibrary
Leave a Comment