select distinct
	VIA_PAT_ID
	, PAT_ERP, IDPATIENTSAPP
	, min(RES_DEBUT_PERIODE) as RES_DEBUT_PERIODE
	, max(RES_FIN_PERIODE) as RES_FIN_PERIODE
from RESULTAT_OBSERVANCE
	inner join VISITE_AGILIS on RES_CLE_AGILIS = VIA_CLE_AGILIS
	inner join PATIENTSAPP on PAT_ID = VIA_PAT_ID and PAT_ERP IN (4, 1)
where COALESCE(RES_ENVOI_TYPE, 0) > 0
	and RES_IMPORT_ALGO = 0
	and VIA_CLE_AGILIS > 0
group by VIA_PAT_ID, PAT_ERP, IDPATIENTSAPP
;

select distinct
VIA_PAT_ID, PAT_ERP
, IDPATIENTSAPP
--, min(RES_DEBUT_PERIODE) as RES_DEBUT_PERIODE
, CONVERT(varchar, min(RES_DEBUT_PERIODE), 112) as RES_DEBUT_PERIODE
--, max(RES_FIN_PERIODE) as RES_FIN_PERIODE
, CONVERT(varchar, max(RES_FIN_PERIODE), 112) as RES_FIN_PERIODE
from RESULTAT_OBSERVANCE
inner join VISITE_AGILIS on RES_CLE_AGILIS = VIA_CLE_AGILIS
inner join PATIENTSAPP on PAT_ID = VIA_PAT_ID and PAT_ERP IN (4, 1)
where COALESCE(RES_ENVOI_TYPE, 0) > 0
and RES_IMPORT_ALGO = 0
and VIA_CLE_AGILIS > 0
group by VIA_PAT_ID, PAT_ERP, IDPATIENTSAPP
;