DECLARE @freq AS INTEGER
DECLARE @facteur AS VARCHAR(4)
SELECT @freq = freq_nbjour, @facteur = freq_facteur_calcul
FROM frequence freq (NOLOCK)
INNER JOIN contrat_proprietaire copo (NOLOCK) ON copo.copo_revision_freq=freq.freq_id
WHERE copo_id=9067
PRINT @freq
PRINT @facteur