DECLARE @REQ_ID VARCHAR(15) = NULL
SELECT @REQ_ID = REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO = '000588/2023/TTr-0692105' 

DECLARE @FROM NVARCHAR(MAX)
SELECT @FROM = CONCAT('FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = ''',@REQ_ID,'''')
EXEC dbo.sp_generate_inserts @table_name = 'CM_REQUEST_TEMPLATE', @from = @FROM
--
SELECT @FROM = CONCAT('FROM CM_SENT_TO_TEMPLATE WHERE TEMPLATE_ID = ''',@REQ_ID,'''')
EXEC dbo.sp_generate_inserts @table_name = 'CM_SENT_TO_TEMPLATE', @from = @FROM
--
SELECT @FROM = CONCAT('FROM CM_APPROVE_GROUP WHERE REQ_ID = ''',@REQ_ID,'''')
EXEC dbo.sp_generate_inserts @table_name = 'CM_APPROVE_GROUP', @from = @FROM
--
SELECT @FROM = CONCAT('FROM CM_TEMPLATE_LOG WHERE REQ_ID = ''',@REQ_ID,'''')
EXEC dbo.sp_generate_inserts @table_name = 'CM_TEMPLATE_LOG', @from = @FROM
--
SELECT @FROM = CONCAT('FROM CM_TEMPLATE_SHARE WHERE REQ_ID = ''',@REQ_ID,'''')
EXEC dbo.sp_generate_inserts @table_name = 'CM_TEMPLATE_SHARE', @from = @FROM
--
SELECT @FROM = CONCAT('FROM CM_TEMPLATE_NOTE WHERE REQ_ID = ''',@REQ_ID,'''')
EXEC dbo.sp_generate_inserts @table_name = 'CM_TEMPLATE_NOTE', @from = @FROM