Project

General

Profile

Download (1.71 KB)

FILE 2 - GET DATA PL.txt

Truong Nguyen Vu, 10/22/2020 09:41 AM

 
1 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC',            -- varchar(776)
2
3 
                             @from = ' FROM PL_REQUEST_DOC WHERE REQ_ID =''PLRD00000200306'' '                 -- varchar(800)
4 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC_DT',            -- varchar(776)
5
6 
                             @from = ' FROM PL_REQUEST_DOC_DT WHERE REQ_ID =''PLRD00000200306'' '                 -- varchar(800)
7 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_TRANSFER',            -- varchar(776)
8
9 
                             @from = ' FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =''PLRD00000200306'' '                 -- varchar(800)
10 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_COSTCENTER',            -- varchar(776)
11
12 
                             @from = ' FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =''PLRD00000200306'' '                 -- varchar(800)
13 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS',            -- varchar(776)
14
15 
                             @from = ' FROM PL_REQUEST_PROCESS WHERE REQ_ID =''PLRD00000200306'' '                 -- varchar(800)
16 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD',            -- varchar(776)
17
18 
                             @from = ' FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =''PLRD00000200306'' '                 -- varchar(800)
19 
EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS',            -- varchar(776)
20
21 
                             @from = ' FROM PL_PROCESS WHERE REQ_ID =''PLRD00000200306'' '                 -- varchar(800)