DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC',            -- varchar(776)

                             @from = ' FROM PL_REQUEST_DOC WHERE REQ_CODE =''0005/2020/TTr-0692205'' '                 -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_DOC_DT',            -- varchar(776)

                             @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)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_TRANSFER',            -- varchar(776)

                             @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)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_COSTCENTER',            -- varchar(776)

                             @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)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS',            -- varchar(776)

                             @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)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD',            -- varchar(776)

                             @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)

EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS',            -- varchar(776)

                             @from = ' FROM PL_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE=''0005/2020/TTr-0692205'') '                 -- varchar(800)