I want to change SQL statement to X++ Code need help

(0) Share

Report

Posted on by Community member

Statement 1 - delete top (333114963) SALESPARMLINE from SALESPARMLINE t where not exists (select 1 from SALESPARMTABLE d where d.Partition = t.Partition and d.dataAreaId = t.dataAreaId and d.ParmId = t.ParmId and d.TableRefId = t.TableRefId)

Statement 2 - delete top (21308858) SALESPARMSUBLINE FROM SALESPARMSUBLINE t where not exists (select 1 from SALESPARMLINE d where d.RecId = t.LineRefRecId)

Categories:

Development / Customization / SDK

Attachments

All responses (4)

Answers (0)

Deepak Agarwal 127 on at

Like (0)

Report

I want to change SQL statement to X++ Code need help

Please clarify the question and what you are trying to achieve .
Suggested answer

Martin Dráb 223,025 Super User on at

Like (0)

Report
I want to change SQL statement to X++ Code need help

Use delete_from statement together with notexists join. Use crossCompany keyword if you want to run it for all companies.

For example:

delete_from crossCompany salesParmLine notexists join salesParmTable where salesParmTable.ParmId == salesParmLine.ParmId && salesParmTable.TableRefId == salesParmLine.TableRefId;
Community member 10 on at

Like (0)

Report

I want to change SQL statement to X++ Code need help

I want it to converted to X++ code for Delete records by creating batchJob
Martin Dráb 223,025 Super User on at

Like (0)

Report

I want to change SQL statement to X++ Code need help

Well, you'll need to tell us what change you want to make and what kind of help you need from us, otherwise we can't do anything for you.