Build Explained

Useful Blogs.

https://axtechsolutions.blogspot.com/2018/08/performing-builds-in-d365.html

https://community.dynamics.com/blogs/post/?postid=80df6b7e-5581-4364-ac99-9d445e7defd9

Useful queries

To select multiple values

 select LOCATIONID, * from LOGISTICSLOCATION where DESCRIPTION IN('Active 4', 'test12')

select LOCATIONID, * from LOGISTICSLOCATION where DESCRIPTION = 'Active 4' OR DESCRIPTION = 'test12'

Exists Join

select * from INVENTTRANS where exists ( SELECT * FROM INVENTTRANSORIGIN where INVENTTRANSORIGIN.RECID = INVENTTRANs.INVENTTRANSORIGIN AND inventTransOrigin.InventTransId = '6135-000654')

select * from CustTable where exists ( SELECT * FROM DirPartyTable where DirPartyTable.RECID = CustTable.PARTY AND DirPartyTable.PRIMARYADDRESSLOCATION = 68719597356)