Hi team,
I have a very simple flow and SQL store procedure, but it is always long running and can't get the result successfully in automate flow.
Here is the SQL store procedure:
create procedure Trade_vw_Val
AS
select sum([AMOUNT]) as "TradeAmt" from [Intervention_2.0].[dbo].[vw_Trade_AIR_NonAIR_Intervention_Del]
EXEC [dbo].[Trade_vw_Val]
and here is the flow I created:
If I ran this SQL in SSMS, only takes 8 secs with below result:
select sum([AMOUNT]) as "TradeAmt" from [Intervention_2.0].[dbo].[vw_Trade_AIR_NonAIR_Intervention_Del]
But I can't succeed in automate flow.
Could you please kindly advise? thank you!