Project

General

Profile

Download (8.97 KB)

DATA TT TASK 525.txt

Luc Tran Van, 10/26/2020 01:06 PM

 
1 
??
2
3
4 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC',            -- varchar(776)
5
6 
                             @from = ' FROM PL_REQUEST_DOC WHERE REQ_CODE =''0005/2020/TTr-0692205'' '                 -- varchar(800)
7 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC_DT',            -- varchar(776)
8
9 
                             @from = ' FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)
10 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_TRANSFER',            -- varchar(776)
11
12 
                             @from = ' FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)
13 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_COSTCENTER',            -- varchar(776)
14
15 
                             @from = ' FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)
16 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS',            -- varchar(776)
17
18 
                             @from = ' FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)
19 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD',            -- varchar(776)
20
21 
                             @from = ' FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)
22 
EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS',            -- varchar(776)
23
24 
                             @from = ' FROM PL_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)
25
26
27
28
29
30 
Tr?ng th?i: Select th?nh c?ng
31
32
33
34 
Column1
35 
INSERT INTO [PL_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[REQ_REASON],[BRANCH_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PROCESS_ID],[DVDM_APP_ID],[REQ_PARENT_ID],[BRANCH_FEE],[EFFEC_DT],[IS_BACKDAY],[DEP_ID],[DEP_FEE],[BRANCH_CREATE],[DEP_CREATE],[REQ_LINE],[TC_NOTES],[SIGN_USER],[KT_NOTES],[IS_CHECKALL],[BASED_CONTENT],[IS_SETTLMENT],[PL_BASED_ID])VALUES(N'PLRD00000200424',N'0005/2020/TTr-0692205',N'V/v Tri?n khai ch??ng tr?nh th?c ?y n?i b? "120 ng?y b?t ph? kinh doanh KHDN"',N'Aug 31 2020 12:00AM',1,N'Tri?n khai ch??ng tr?nh th?c ?y n?i b? nh?m tng tr??ng t?n d?ng KHDN k?t h?p b?n ch?o c?c s?n ph?m : Th?u chi v? IB, th? t?n d?ng, payroll v? bancas trong 4 th?ng cu?i nm 2020.',N'Tri?n khai ch??ng tr?nh th?c ?y n?i b? "120 ng?y b?t ph? kinh doanh KHDN"',N'DV0001',201000000,NULL,N'1',N'liennth',N'Oct 21 2020 12:00AM',N'E',NULL,NULL,N'',NULL,NULL,N'DV0001',NULL,1,N'DEP000000000062',N'DEP000000000062',N'DV0001',N'DEP000000000062',NULL,NULL,NULL,NULL,0,N'Quy?t ?nh 149/2020/Q-HC ng?y 21/5/2020 v? vi?c Ban h?nh Quy ?nh mua s?m h?ng h?a d?ch v?; Cn c? nhu c?u mua s?m th?c t?',NULL,NULL)
36
37 
Column1
38 
INSERT INTO [PL_REQUEST_DOC_DT] ([REQDT_ID],[REQ_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[NAME],[DESCRIPTION],[REQDT_TYPE],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DVDM_ID],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[SUP_ID],[TRADE_TYPE],[KHOI_ID],[UNIT_NAME])VALUES(N'PLRDD0000204297',N'PLRD00000200424',N'PLM000001056650',N'PLT000001062955',N'GOO000001062455',N'',N'Tri?n khai thi ua d?nh cho CBO/ VKD v? th?c hi?n chi th??ng h?ng th?ng cho c?c CBO ?t gi?i v? chi th??ng cho VKD ?t gi?i v?o cu?i ch??ng tr?nh. S? th?ng tri?n khai l? 4 th?ng.',N'I',N'CMU000000000047',1,201000000.00,201000000.00,N'1',N'liennth',N'Oct 21 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000077',N'HH0000000112299',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000023',N'G?i')
39
40 
Column1
41 
INSERT INTO [PL_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[DVMD_ID],[TOTAL_AMT_GD])VALUES(N'PLRC00000202234',N'DM0000000000077',N'PLRD00000200424',N'',N'E',N'liennth',N'Oct 21 2020 12:00AM',NULL,NULL,NULL,NULL)
42
43 
Result ErrorDesc
44 
SUCCESSFULL
45