SELECT personalid,
MIN(CASE planid WHEN '101' THEN checkdate END) f101,
MIN(CASE planid WHEN '151' THEN checkdate END) f151
FROM EPIVPerson
GROUP BY personalid;
MIN(CASE planid WHEN '101' THEN checkdate END) f101,
MIN(CASE planid WHEN '151' THEN checkdate END) f151
FROM EPIVPerson
GROUP BY personalid;
MIN(CASE WHEN planid = '101' THEN checkdate END) f101,
MIN(CASE WHEN planid = '151' THEN checkdate END) f151
FROM EPIVPerson
GROUP BY personalid;
MIN(CASE WHEN planid = '101' THEN checkdate END) f101,
MIN(CASE WHEN planid = '151' THEN checkdate END) f151
FROM EPIVPerson
GROUP BY personalid,name,brithdate;