Delete Specific records from a SQL table with a clause

[urfriendumesh]

I'm trying to perform a match of a specific set of records (Input-1 : Text Input or Excel sheet) with a SQL table (Input-2). All the records matched need to be Deleted from the SQL table (Input-2).

I have designed a workflow and able to get the required matched records in a SELECT statement using Dynamic Input, but unable to DELETE these records from the table. Can you please assist in dynamically deleting the matched records. Attached the workflow for reference.

[Felipe_Ribeir0 · Accepted solution]

Hi @urfriendumesh 

Try using this select 1 before the delete query, inside of the dynamic input.

SELECT 1;
DELETE FROM

"RMS"."dbo"."LegalHoldFiles_BKP"

WHERE r_object_id='0b0000c9800f3378' AND unique_ref_no='758'

Here is how i have this same situation configured here, it works well:

[urfriendumesh]

Thanks @Felipe_Ribeir0 for the solution. I was able to execute the workflow with Dynamic SQL Delete.

[bobmay]

I tried this using dynamic Input:

Select 1; 

delete from SANDBOX.ADMIN.MYID_TEST

where BRAND = 'brand_value'

I replace brand_value with an actual brand name

but I am getting an error: Error opening .... No Columns returned.