This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Been fighting with SQL update / delete and here is a working solution.
1. Add input value you want to refer to in your update/delete statement
2. Add dynamic input; define connection to sql server as usual (make sure you're using odbc connection.) in a Table or Query write "Select 1; Delete from table_name where id = existing_value" (In fact you need to pass any valid True statement separated by semicolon from main Update / Delete statement)
3. In the dynamic input properties choose Modify SQL Query; add SQL: Update WHERE Clause like in usual insert:
I have query build for SQL Developer and I would like to modify the date range based on your above example, however when I try to use the "Dynamic input" ( Other Database + 32 bit data base connections + ODBC) it doesn't appear any option.