Gizmokid2005

Keybase proof

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:

Gizmokid2005

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')

Gizmokid2005

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