Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery
SELECT distinct SERV_CALL.REPRESENTATIVE AS REP, CUSTOMR_SHIP_TO.CUS_POSTAL_CODE_1 AS ZIP, SERV_CALL.COMPLETE_DATE_SCA FROM SERV_CALL INNER JOIN SERIAL_EQUIP ON SERV_CALL.SERIAL = SERIAL_EQUIP.SERIAL INNER JOIN CUSTOMR_SHIP_TO ON SERIAL_EQUIP.CUSTOMER_NUMBER = CUSTOMR_SHIP_TO.CUSTOMER_NUMBER WHERE (SERV_CALL.COMPLETE_DATE_SCA > '01/01/2009') AND (CUSTOMR_SHIP_TO.CUS_POSTAL_CODE_1 <> '') order by SERV_CALL.COMPLETE_DATE_SCA DESC
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!