Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE project_tr SET is_withdraw = 1 WHERE project_tr_id IN (1099,1225,1226);
- UPDATE project_tr SET is_delete = 1 WHERE project_tr_id IN (23,24,25,26,29,33,37,1111,1112,1113,1114,1117,1360,4,8,40,43,45,47,48,49,50,52,56,59,64,65,73,76,79,88)
- UPDATE project_tr SET propose_total_funding = '11329555' WHERE project_tr_id LIKE '1095';
- UPDATE pillar_tr SET is_main_pillar = '1' WHERE pillar_tr_id LIKE '1290';
- UPDATE pillar_tr SET type_of_pillars_id = '1650' WHERE pillar_tr_id LIKE '1291';
- UPDATE project_tr SET propose_total_funding = '10496880' WHERE project_tr_id LIKE '1096';
- UPDATE pillar_tr SET is_main_pillar = '1' WHERE pillar_tr_id LIKE '1292';
- UPDATE project_tr SET propose_total_funding = '4408960' WHERE project_tr_id LIKE '1101';
- UPDATE pillar_tr SET is_delete = '1' WHERE pillar_tr_id IN ('1306','1307','1308');
- INSERT INTO [dbo].[pillar_tr] ([project_trx_id], [type_of_pillars_id], [is_main_pillar], [is_delete], [create_date], [modify_date], [user_id_create], [user_id_modify]) VALUES ('1101', '1391', '1', '0', getdate(), NULL, '1', NULL);
- UPDATE project_tr SET propose_total_funding = '3042182.4' WHERE project_tr_id LIKE '1104';
- UPDATE project_tr SET propose_total_funding = '0' WHERE project_tr_id LIKE '2402';
- UPDATE project_funding_source_tr SET is_delete = '1', funding_source_id = '0' WHERE project_funding_source_tr_id LIKE '2316';
- UPDATE project_tr SET proposal_id = 'SEM/SEM/21/001/REG' WHERE project_tr_id LIKE '2489';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement