Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I set a variable at the beginning of my script, and I would like to assign this variable to every row of data in my sql select statement.
The variable is called vTmp and this is how I am trying to incorporate it but it is not working.
LOAN:
SQL SELECT
"Account_Phone",
"Account_Type",
"Risk_Raiting",
$(vTmp)
FROM "database".dbo."table";
Is this technique possible?
Thanks
You may need to use Preceding Load something like this :
LOAN:
Load
*
$(vTmp)
;
SQL SELECT
"Account_Phone",
"Account_Type",
"Risk_Raiting",
$(vTmp)
FROM "database".dbo."table";
maybe
'$(vTmp)'
what's your variable?
You may need to use Preceding Load something like this :
LOAN:
Load
*
$(vTmp)
;
SQL SELECT
"Account_Phone",
"Account_Type",
"Risk_Raiting",
$(vTmp)
FROM "database".dbo."table";
It´s possible, what is the content of your variable?