Hi,
I want to execute an sql select query, which will return a single value and use that value for the next step in automation. Can I directly get that value after the query execution or store that value in a variable.
Hi,
I want to execute an sql select query, which will return a single value and use that value for the next step in automation. Can I directly get that value after the query execution or store that value in a variable.
Use Database: Export to data table to get the result in a table.
If you query returns only one row and one column you can store the value like below or assign it to another variable.
HTH
Regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.