Ask a Question

Dynamic query, temp table, insert select


Dynamic query, temp table, insert select



I went thru this older post


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 



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)




Community Hero

Re: Dynamic query, temp table, insert select

Hey @anand1,

I dunno if i can help, but i'll try and reproduce the issue on my readyapi!/sqlserver instance.

Im using readyapi! v3.3.0, what version are you using? Im gonna assume its not a driver problem cos you say it works using groovy, but not the embedded functionality, right?

Can you attach the storedproc so i get a feel for what its doing? I'll try and build an sp on my instance replicating the basics of your sp.

Nice one,

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Community Manager

Re: Dynamic query, temp table, insert select

Thanks Richie!


Hi @anand1 ! The Community will be happy to help you, but we need some more info (refer to Richie's reply).

Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

Re: Dynamic query, temp table, insert select

Thanks @richie 


Please find one of the Proc below


Let me know if you need any other information, apology for late response.




Showing results for 
Search instead for 
Did you mean: