How to execute a SQL query which includes temp table ( creates and inserts ) - JDBC Step

[Bishal]

I have a JDBC test step with a SQL Query which  has a temp table on it. I am not able to execute this query. Every time i try to execute i get below XML response. Anyone has any idea? Thanks. 

<Results>
<UpdateCount>124</UpdateCount>
</Results>

[Bishal · Accepted solution]

This is solved, i used

def a = context.expand( '${DataSource#a}' )
def b = context.expand( '${DataSource#b}' )

sql.eachRow("""Declare @PortfolioOldCode varchar(3) = ${a},
@EndDate Date = ${b},

insted of 

sql.eachRow("""Declare @PortfolioOldCode varchar(3) = context.expand( '${DataSource#a}' ),
@EndDate Date = context.expand( '${DataSource#b}' )

or

sql.eachRow("""Declare @PortfolioOldCode varchar(3) = a,
@EndDate Date = b

-- Thanks for helping in guys 

[peti2005]

I do not see the original issue resolved as still CREATE command is not working from JDBC test step. At least for me. I started one more topic to for the same issue: https://community.smartbear.com/t5/SoapUI-Open-Source/CREATE-TABLE-does-not-work-from-JDBC-test-step...