How to execute an SQL query which also has temp table in it

I have an sql query in which there is also a temp table being created at run time. when i execute the query from Sql server it returns me data but the same query when run in soapui through JDBC Request it returns me as below.

<Results>
<UpdateCount>0</UpdateCount>
</Results>