1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Select nom_materiel, valeur as date , libelle , nom_agence, nom_type_mat
from
parc_materiel_caracteristiques as t1 ,
parc_criteres as t2,
agence as t3,
parc_materiel as t4,
parc_type_materiel as t5
where t1.no_critere = t2.no_critere
and t3.num_agence = t4.num_agence
and t1.num_mat = t4.num_materiel
and t5.num_type_mat = t4.num_type_mat
and valeur
not in (select valeur from parc_materiel_caracteristiques
where (isdate(valeur) = 0 and isnumeric(valeur) = 0 )
or (isdate(valeur) = 0 and isnumeric(valeur) = 1 )
or (isdate(valeur) = 1 and isnumeric(valeur) = 1 ))
and valeur
between convert(varchar, '01/06/2009', 103)
and convert(varchar, '31/12/2009', 103)
order by convert(datetime, valeur, 103) asc |
Partager