Tuesday, September 23, 2025

How to update column Based on joins in sql

 How to update column Based on joins in sql :-


UPDATE GeneralJournalAccountEntry

SET IS_ConsolidationMainAccount = '',

 IS_ConsolidateAccountName = ''

FROM GeneralJournalAccountEntry AS GJAE

 JOIN GeneralJournalEntry AS GJE

    ON GJE.RecId = GJAE.GeneralJournalEntry

WHERE GJE.SubledgerVoucherDataAreaId = 'VN06'

and GJE.ACCOUNTINGDATE > '2025-01-01'

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to handle DB restore error.

 ERROR;- The transaction log for database 'AXDB_NewCON' is full due to 'ACTIVE_TRANSACTION'. If this error occurs, it means ...

  • Posting Pending Vendor Invoice In d365 fo X++
      As per the standard when a pending vendor invoice is created and posted, it will not populate the data to description field in the vendtra...
  • Trace parser
    In this blog, I'm explaining how to Use the trace parser tool in D365FO. Any application at some point faces slow performance issues. It...
  • How to find country region code in D365 fo X++
     How to find the country region code in D365 for X++ LogisticsAddressCountryRegion::findByISOCode(SysCountryRegionCode::countryInfo(curext()...