1 2 3 4 5 6 7 8 9 10 11 12 13 14
| SELECT exe.[execution_id]
,CASE When exeEvts.eventcode='CANCELLED' Then 'Event ' + exeEvts.eventcode + ' on ' + convert(varchar, exeEvts.created_on, 13) + ' Error: ' + exeEvts.description Else 'Event ' + exeEvts.eventcode + ' on ' + convert(varchar, exeEvts.created_on, 13) End
, exeEvts.created_on as log_datetime
FROM [BLL_EDI_CONTRACTMGMT].[dbo].[bll_contractExecution] as exe
LEFT OUTER JOIN [BLL_EDI_CONTRACTMGMT].[dbo].[bll_contractExeEvents] as exeEvts
ON exe.[execution_id] = exeEvts.[execution_id]
UNION all
SELECT exe.[execution_id]
, rtbl.rule_name + ' ' + ruleEvts.eventcode + ' on ' + convert(varchar, ruleEvts.created_on, 13)
, ruleEvts.created_on as log_datetime
FROM [BLL_EDI_CONTRACTMGMT].[dbo].[bll_contractExecution] as exe
LEFT OUTER JOIN [BLL_EDI_CONTRACTMGMT].[dbo].[bll_ruleExeEvents] as ruleEvts
LEFT OUTER JOIN [BLL_EDI_CONTRACTMGMT].[dbo].[bll_rule] AS rtbl ON ruleEvts.rule_id = rtbl.rule_id
ON exe.[execution_id] = ruleEvts.[execution_id] |
Partager