There is a challenge I am facing where I need some long SQL scripts like SQL stored procedures to run and return the results to User Interface and then send it through Email. What I know is that we can run some small SQL queries and can then return the results. Normally stored procedure like scripts have some different output and format in SQL Server comparing to when we are running small SQL queries. Is there a efficient way to put back the results from SQL Server into UI through UIPath?
youtube video for the same -