1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
select tab,vue.id,'scc|' + rtrim(ltrim(str(coalesce(id_structures_contact_communication,0)))) as cle,
vue.[id_utilisateur],coalesce([id_suivi],0) as id_suivi,vue.[dcr],
coalesce([id_champ_valeur_adresse],0) as id_champ_valeur_adresse,[ville],[cp],[region],[pays],[adresse_long],[adresse_court],
[email],[emadir],[telephone],[teldir],
[mobile],[mobdir],[site],[sitedir],vue.[libelle],[isole],[fonction],ext_photo_str,ext_photo_con,id_str,id_con,
[id_structures_contact_communication],[adresse],[libelle_structure] as groupdate,1 as ordtri,0 as nbregroupe
from (select t1.*,t2.libelle_structure from
(select * from Fnc_structures_contact_communication(58985,0,12) where id_communication=58985) as t1
INNER JOIN
(select * from fnc_strconcom_strcon(58985)) as t2 ON
coalesce(t1.id_structures_contact_communication,0)=coalesce(t2.id_structures_contact_communication,1)) as vue
UNION
select '' as tab,0 as id,'grp|' + rtrim(ltrim(str(coalesce(id_structure,0)))) as cle,0 as id_utilisateur,0 as id_suivi,null as dcr,
0 as id_champ_valeur_adresse,
null as ville,null as cp,null as region,null as pays,null as adresse_long,null as adresse_court,null as email,0 as emadir,null as telephone,
0 as teldir,null as mobile,0 as mobdir,null as [site],0 as sitedir,[libelle_structure] as libelle,0 as isole,null as fonction,
null as ext_photo_str,null as ext_photo_con,0 as id_str,0 as id_con,0 as id_structures_contact_communication,'' as adresse,
[libelle_structure] as groupdate,0 as ordtri,count(*) as nbregroupe
from fnc_strconcom_strcon(58985) group by id_structure,libelle_structure |
Partager