Accès à leur BDD 

> serveur : base-3c.a26.fr
> identifiant : ext_3C_waka
> password : hd8[t:kpy3C/Er!,


[[https://3c.a26.fr/dossier/public/help/views.aspx]]


<code>
SELECT TOP 50 
d.RefDossier, 
d.DateJourJ, 
d.DateRMission,
DATEDIFF(DAY, d.DateJourJ, d.DateRMission) AS diff
FROM V_DOSSIER d
ORDER BY d.DateJourJ DESC;
</code>