SQL "Delete From"

[Matthew]

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')

[kathleenmonks]

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!