Project

General

Profile

Download (1.5 KB)

GET DATA.txt

Truong Nguyen Vu, 11/13/2020 12:01 PM

 
1 
EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC',            -- varchar(776)
2
3 
                             @from = 'FROM PL_REQUEST_DOC WHERE REQ_ID =''PLRD00000200156'''                  -- 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 =''PLRD00000200156'''                  -- 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 =''PLRD00000200156'''                  -- 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 =''PLRD00000200156'''                  -- 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 =''PLRD00000200156'''                  -- varchar(800)
16 
EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS',            -- varchar(776)
17
18 
                             @from = 'FROM PL_PROCESS WHERE REQ_ID =''PLRD00000200156'''                  -- varchar(800)