How to use a variable in Execute SQL Script

Hey everyone! I have a workflow, inside it I have a get system infos to get yesterday’s day and a rename fields to transform yesterday’s day into the format yyyyMMdd, after that I run a sql script, inside this script I have a where clause that I need check if the column itself is the same as my variable from the previous day. How do I do that?

1 Like

the variable must be listed in the Parameter section and the query insert question marks in the place where the parameter should be filled in.
Mark execution for each row and variable substitution and you should be OK.
parameter list should be generated in the same sequence as question marks to be filled in.
Hope this helps

1 Like