Hi,
SELECT ENUMVALUETABLE.ENUMID, ENUMVALUETABLE.ENUMVALUE, ENUMVALUETABLE.NAME
FROM ENUMVALUETABLE
INNER JOIN ENUMIDTABLE ON ENUMIDTABLE.ID = ENUMVALUETABLE.ENUMID
where ENUMIDTABLE.NAME = 'ProjOrigin'
Regards,
The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Hi,
SELECT ENUMVALUETABLE.ENUMID, ENUMVALUETABLE.ENUMVALUE, ENUMVALUETABLE.NAME
FROM ENUMVALUETABLE
INNER JOIN ENUMIDTABLE ON ENUMIDTABLE.ID = ENUMVALUETABLE.ENUMID
where ENUMIDTABLE.NAME = 'ProjOrigin'
Regards,
Hi,
dateMthFwd( _projTable.StartDate, 12*9) ;
Thanks,
Hi, update companyimage set companyimage.Image = companyimageA.Image from ( select Image from companyimage where dataAreaid = 'USF...