Dynamic query, temp table, insert select
Hi, I went thru this older post https://community.smartbear.com/t5/SoapUI-Pro/Stored-Proc-DYNAMIC-SQL-returns-no-rows/td-p/42621 And i also have the similar problem, I am creating a temp table, inserting the data using a SP and then doing some select based on my criteria I am using JDBC test step in my test case to execute this, whenever I am executing it, I am not getting any error, instead i m getting <Results> <UpdateCount>0</UpdateCount> </Results> Although, I expect the output of my Select query which is my last statement. I can see it use to be a bug in earlier version. Not sure if that is still an issue, or am I missing something. Thanks in advance. P.S: It is working fine if I am executing the same in SSMS(Sql Server Management Studio) Regards, Andy1.5KViews0likes3Comments