hello, all
i am trying to run a dynamic SQL query that will delete rows from a table when the row ID is in a list.. i swear i got it to work before, but now i cant figure it out
i'm using a dynamic input tool with the following query, and the dynamic input replaces 'xxx' with the list of IDs, but it's not working
delete from
[Database].[Schema].[Table]
where
[Record_ID] in ('xxx')
Hi @Matthew,
It looks like the user in this discussion solved this problem using an Update WHERE clause in the dynamic input and putting the "delete from" section in the connection query section.
Let me know if this solves your problem!
@kathleenmonks I'm looking into this same issue the OP had. When I go to the link you provided it takes me to a "This Content was Archived". Do you know how I can get to the page you were trying to share? TIA