Delete Specific records from a SQL table with a clause
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Output
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Felipe_Ribeir0 for the solution. I was able to execute the workflow with Dynamic SQL Delete.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
