Delete Specific records from a SQL table with a clause

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.

DeleteData-SQL Table.yxmd

Workflow

Designer Cloud

Output

Accepted answers

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:

All comments

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:

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

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.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703