lay_data.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15) = NULL |
|---|---|
| 2 |
SELECT @REQ_ID = REQUEST_TEMPLATE_ID FROM CM_REQUEST_TEMPLATE WHERE REPORT_NO = '000588/2023/TTr-0692105' |
| 3 |
|
| 4 |
DECLARE @FROM NVARCHAR(MAX) |
| 5 |
SELECT @FROM = CONCAT('FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = ''',@REQ_ID,'''')
|
| 6 |
EXEC dbo.sp_generate_inserts @table_name = 'CM_REQUEST_TEMPLATE', @from = @FROM |
| 7 |
-- |
| 8 |
SELECT @FROM = CONCAT('FROM CM_SENT_TO_TEMPLATE WHERE TEMPLATE_ID = ''',@REQ_ID,'''')
|
| 9 |
EXEC dbo.sp_generate_inserts @table_name = 'CM_SENT_TO_TEMPLATE', @from = @FROM |
| 10 |
-- |
| 11 |
SELECT @FROM = CONCAT('FROM CM_APPROVE_GROUP WHERE REQ_ID = ''',@REQ_ID,'''')
|
| 12 |
EXEC dbo.sp_generate_inserts @table_name = 'CM_APPROVE_GROUP', @from = @FROM |
| 13 |
-- |
| 14 |
SELECT @FROM = CONCAT('FROM CM_TEMPLATE_LOG WHERE REQ_ID = ''',@REQ_ID,'''')
|
| 15 |
EXEC dbo.sp_generate_inserts @table_name = 'CM_TEMPLATE_LOG', @from = @FROM |
| 16 |
-- |
| 17 |
SELECT @FROM = CONCAT('FROM CM_TEMPLATE_SHARE WHERE REQ_ID = ''',@REQ_ID,'''')
|
| 18 |
EXEC dbo.sp_generate_inserts @table_name = 'CM_TEMPLATE_SHARE', @from = @FROM |
| 19 |
-- |
| 20 |
SELECT @FROM = CONCAT('FROM CM_TEMPLATE_NOTE WHERE REQ_ID = ''',@REQ_ID,'''')
|
| 21 |
EXEC dbo.sp_generate_inserts @table_name = 'CM_TEMPLATE_NOTE', @from = @FROM |