Hi all.
I have a stored procedure (quite lengthy that creates a temporary table and then deletes it) that I have managed to get to run in JDBC Query Consumer (in full mode). This procedure performs the query to SQL Server and on average it takes about 9 minutes to get the result of the execution from a database manager. The issue is that when I perform a "Preview" it does not bring me the same data and what it brings, it brings it incomplete. Do you know what could be affecting the result?
I used the query directly and the query improved a little but not completely.
I also tried in "Test Run" but it does not give me the result of the query.
What could it be?