10/31/2023 0 Comments Crystal reports 2013 trial download![]() Max(case when meas.flo_meas_id in ('6230','3040101397') then to_number(as_value) -Fresh Plasma Trns Max(case when meas.flo_meas_id = '6256' then to_number(as_value) -CRYO Max(case when meas.flo_meas_id = '11215852' then to_number (as_value) -CELL Saver Max(case when meas.flo_meas_id = '6214' then to_number(as_value)-Est Blood Loss Max(TO_CHAR(endt.TRACKING_TIME_IN ,'HH24:MI')) as OutTime, Max(TO_CHAR(startt.TRACKING_TIME_IN ,'HH24:MI'))as InTime, Max(case when staff.staff_type_c = '70' then perf.prov_name -Perf Name LEFT OUTER JOIN EPICADM.ORDER_RESULTS ORDER_RESULTS ON (ORDER_PROC.ORDER_PROC_ID = ORDER_RESULTS.ORDER_PROC_ID INNER JOIN base_pats on ORDER_PROC.PAT_ID = base_pats.pat_id ![]() LEFT JOIN EPICADM.V_FV_MRN VF2 ON ORDER_PROC.PAT_ID = VF2.PAT_ID LEFT OUTER JOIN EPICADM.ORDER_PROC_2 ORDER_PROC_2 ON (ORDER_PROC.ORDER_PROC_ID = ORDER_PROC_2.ORDER_PROC_ID , ROW_NUMBER() OVER(PARTITION BY ORDER_PROC.PAT_ID ORDER BY ORDER_PROC_2.SPECIMN_TAKEN_TIME ASC NULLS LAST) ENC_RANK , ORDER_PROC_2.SPECIMN_TAKEN_TIME as Collect_time ![]() ![]() , ORDER_PROC_2.SPECIMN_TAKEN_DATE as Collect_date How can I replace the red section below with the following? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |