I'm trying to execute a query and return results to PA. I can't get the query to run successfully with a parameter...although I can hardcode the parameter and the query works fine. It picks up the parameter input but never returns a ResultSet.
Declare @UnitNumber int SELECT AVG(SOSTotalTime) AS AverageSOS, DayPart FROM dbo.vw_SOSbyOrder Where UnitNumber=@UnitNumber GROUP BY DayPart
I am trying to something similar and followed this video:
2 minutes and 20 seconds into the video, he saves the flow and refreshes the page, which makes the variable appear.
I cannot get this to appear, which I think maybe the issue we are both facing.
Has anyone else faced this issue?