This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm not aware of any built in limits for results returned from stored procedures. I've returned millions of rows in the Input and Dynamic Input tools. I don't the use pre- and post-SQL statements often so there may be a limit there, but I would be surprised.
The obvious question, that I'm sure you've already explored before posting is: Are you sure that the SQL executed in SSMS is the same as that executed in Alteryx. i.e. All the parameters have the same values and the input data to your stored procedure is the same in both cases
Yes I did run the same stored proc directly through SQL Server Management Studio and its giving the correct number for Records. But when using the Same stored proc with same parameter in Alteryx its not returning the same number of record. To identify the where is the actual problem here is what I did.
Actual Input count as 44K, Run through SSMS Stored Proc(SP) returns 44k but when I run through Alteryx it returned only 36K
Then I reduced the Input count as 30K , Run through SSMS , SP returns 30 K and run through Alteryx returned 30K
Then I increased the Input count to 37K , Run through SSMS, SP returns 37 K and when I run through Alteryx it only return 36K
so I think there is some where memory limitation which is creating this issue. But I am not sure what is happening exactly.
Is there a way you can try executing the same sql statements through Alterxy (not the whole stored procedure , just the piece of SQL code which you think could be problematic ) and see how many records are returned?
Yes you can run a certain piece of query in input data tool configuration, If you are using odbc or sqlite or any other connection there you see an option of table or query there you can write your custom query, test it and then run it for your desired output.
@UpendraPandey - I was suggesting that you can try executing the same sql statements through Alterxy (not the whole stored procedure , just the piece of SQL code which you think could be problematic ) and see how many records are returned?