Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
SELECT DISTINCT SUBSTRING(T_DROMOS.TXCODE,1,2) AS ZONI_ID, T_DROMOS.TXCODE, T_DROMOS.TXDESC, T_DROMOS.TXJAC1, T_DROMOS.TXCHAM, CASE WHEN CONTROL.COADR1 Like '%VLACHOS%' OR CONTROL.COADR2 Like '%VLACHOS%' OR CONTROL.COADR3 Like '%VLACHOS%' THEN 1 WHEN CONTROL.COADR1 Like '%FANOURIOU%' OR CONTROL.COADR2 Like '%FANOURIOU%' OR CONTROL.COADR3 Like '%FANOURIOU%' THEN 2 WHEN CONTROL.COADR1 Like '%LOUCA%' OR CONTROL.COADR2 Like '%LOUCA%' OR CONTROL.COADR3 Like '%LOUCA%' THEN 3 ELSE -1 END AS ENORIAID FROM T_DROMOS INNER JOIN TXCONN ON T_DROMOS.TXCODE=SUBSTRING(TXCONN.TXTAXC,1,5) INNER JOIN CONTROL ON TXCONN.TXTAXP=CONTROL.COCODE;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|how to resize column length with primary ket||4||34|
|How to sort columns on a continuous form populated by resetting the recordet, as when a recordset is returned from a stored procedure?||5||48|
|error 80020009 - cannot add record(s); join key of table '...' not in record set||5||38|
|Word 2016 (32-Bit) - Hangs when attempting to select an existing list for Mailings||13||30|
Join the community of 500,000 technology professionals and ask your questions.