[ dado49 @ 21.05.2006. 15:43 ] @
Dali neko moze da mi pomogne da malo pojednostavim ovaj kod: SELECT COUNT(*) AS number FROM sd_Person WHERE (cpr IN (SELECT cpr FROM sd_person_profession WHERE til_dato > getdate())) AND (cpr IN (SELECT cpr FROM sd_person_department WHERE til_dato > getdate() AND departmentcode IN (SELECT level0code FROM sd_organization WHERE level3code = 'IT-S') AND cpr IN (SELECT cpr FROM sd_person_status WHERE til_dato > getdate() AND statuskode NOT IN ('3', '7', '8', '9') AND sd_person_status.institutionskode = sd_person_status.institutionskode AND sd_person_status.tjenenumb= sd_person_status.tjenenumb))) AND (cpr <> '0000000000') |