If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
SELECT A.ID FROM EMPLOYEES E INNER JOIN SITES S ON S.ID = PS.SITE_ID INNER JOIN LOCATIONS SL ON S.ID = SL.SITE_ID WHERE SL.ID = 221 AND NOT EXISTS( SELECT 1 FROM EMPLOYEE_INSTANCES EMP_INNER ,POLICY_SITES PS WHERE EMP_INNER.EMP_ID =E.ID AND EMP_INNER.STATUS ='V' AND E.POLICY_ID=PS.POLICY_ID AND PS.SITE_ID=SL.SITE_ID AND EMP_INNER.LOCATION_ID =SL.ID GROUP BY SITE_ID,PS.TOTAL_COPIES HAVING PS.TOTAL_COPIES = COUNT(DISTINCT EMP_INNER.LOCATION_ID) )
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!