At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.
select s.study_iuid from pacsdb.patient p INNER JOIN study s on p.pk = s.patient_fk /***where p.pk = s.patient_fk***/ where s.mods_in_study NOT LIKE '%MG%' /***and s.mods_in_study NOT LIKE 'RTIMAGE'***/ and s.study_datetime IS NOT NULL and p.pat_birthdate IS NOT NULL and ISDATE(p.pat_birthdate) = 1 and ISDATE(s.study_datetime) = 1 and CASE WHEN ISDATE(s.study_datetime) = 1 THEN s.study_datetime END <= DATEADD(DAY, -2192, GETDATE()) and CASE WHEN ISDATE(p.pat_birthdate) = 1 THEN p.pat_birthdate END <= DATEADD(DAY, -7670, GETDATE());
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.