1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| ---/* requête finale PDA */---
select top 10000
c.CtcNamDsc + ' ' + c.CtcFstNamDsc as Utilisateur,
a.ObjIdentVal as "Identification",
d.ObjCharVal as "Numéro de série",
b.ObjCharVal as "Numéro IMEI",
e.ObjCharVal as "Numéro carte SIM",
f.ObjCharVal as "Numéro IMSI",
h.ObjCharVal as "Commentaires"
from p_Dos a
join p_Ctc c on c.CtcInCde = a.CtcInCde
join p_ObjChar b on a.ObjInCde = b.ObjInCde and a.DosInCde = b.DosInCde
join p_ObjChar d on a.ObjInCde = d.ObjInCde and a.DosInCde = d.DosInCde
join p_ObjChar e on a.ObjInCde = e.ObjInCde and a.DosInCde = e.DosInCde
join p_ObjChar f on a.ObjInCde = f.ObjInCde and a.DosInCde = f.DosInCde
join p_ObjChar h on a.ObjInCde = h.ObjInCde and a.DosInCde = h.DosInCde
where a.ObjInCde = 598 and CpyInCde = 1000
and d.CharInCde = 4
and b.CharInCde = 48
and e.CharInCde = 25
and f.CharInCde = 52
and h.CharInCde = 22
order by Utilisateur |
Partager