Get enum value of a Enum in SQL- D365

 Hi,

SELECT

    et.Name AS enumIdName, 
    ev.EnumValue AS enumValue, 
    ev.Name AS enumValueName
FROM EnumIdTable et
INNER JOIN EnumValueTable ev 
    ON et.Id = ev.EnumId
WHERE et.Name = 'LedgerPostingType'
  AND ev.Name = 'PurchPckSlpPurchaseOffsetAccount';

Regards

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi,

update companyimage
set 

companyimage.Image  = companyimageA.Image 

from

 ( select Image from companyimage where dataAreaid = 'USFM' and imagetype = 1) as companyimageA 
where

 dataAreaid != 'USFM' and imagetype = 1

 

Regards