/** TEST SCRIPT FOR CONTACT */
-- SELECT * FROM PatientProfile
-- DELETE FROM PatientContacts WHERE PatientContactsId = 362
-- DELETE FROM PatientRelationship WHERE PatientRelationshipId = 10642

DECLARE @PatientId VARCHAR(20) = '661';

EXEC cus_HS_CW_Insert_Contact @PatientId, 'Emergency', 'Joe Mc Biden', '5556667779';
-- UPDATE PatientContacts SET middle = '' WHERE PatientContactsId = 367

SELECT *
FROM PatientProfile
WHERE PatientId = @PatientId

SELECT pr.*
FROM PatientRelationship pr
WHERE pr.PatientProfileId = (
	SELECT PatientProfileId
	FROM PatientProfile
	WHERE PatientId = @PatientId
);

SELECT pc.*
FROM PatientContacts pc
JOIN PatientRelationship pr ON pr.RelatedPartyId = pc.PatientContactsId
WHERE  pr.PatientProfileId = (
	SELECT PatientProfileId
	FROM PatientProfile
	WHERE PatientId = @PatientId
);