I hereby claim:
- I am gizmokid2005 on github.
- I am gizmokid2005 (https://keybase.io/gizmokid2005) on keybase.
- I have a public key ASBuIGn56fvVc-hBApZTkW7ao430JJOoXa-nRCe28Z5YVQo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
SELECT | |
DISTINCT | |
patient_id | |
FROM | |
procedures as pr | |
join patients as pa on pa.patient_id = pr.patient_id | |
WHERE | |
pr.TimeOfService >= '01/01/2010' | |
AND NOT EXISTS (SELECT * FROM procedures AS pr2 WHERE pr2.patient_id = pr.patient_id AND pr.TimeOfService < '01/01/2010') |
UPDATE Customers | |
SET Addr1 = COALESCE(NULLIF(Addr1,''),NULLIF(Addr2,''),NULLIF(Addr3,'')) | |
,Addr2 = COALESCE(NULLIF(Addr2,''),NULLIF(Addr3,'')) | |
,Addr3 = CASE WHEN Addr2 = Addr3 THEN NULL ELSE Addr3 END |