DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

DECLARE @REQ_ID VARCHAR(15)

SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE='PUR/2023/000627'

DECLARE @FROM1 VARCHAR(800) = 'FROM TR_REQUEST_DOC trd WHERE trd.REQ_ID = '''+ @REQ_ID + '''';

DECLARE @FROM2 VARCHAR(800) = 'FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = '''+ @REQ_ID + '''';

DECLARE @FROM3 VARCHAR(800) = 'FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT ID FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = '''+ @REQ_ID + ''')';

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

@from = @FROM1 -- varchar(800)

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

@from = @FROM2 -- varchar(800)

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

@from = @FROM3 -- varchar(800)