1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
create table #MKT_EFFEC_PREC
(
CLI_ORIGINE varchar(6),
ANNEE int,
MOIS int,
PSU_CODE char(4),
FTP_CODE char(4),
FAC_CA money,
FAC_CA_PREC money,
FAC_CA_CUMULE money,
FAC_VOL numeric(30,2),
FAC_VOL_PREC numeric(30,2),
FAC_VOL_CUMULE numeric(30,2)
)
insert into #MKT_EFFEC_PREC
select 'MDP',ANNEE,MOIS,PSU_CODE,FTP_CODE,sum(FAC_CA),sum(FAC_CA_PREC),0,sum(FAC_VOL),sum(FAC_VOL_PREC),0 from #LISTE_CLIENTS where CLI_ORIGINE='M'
group by PSU_CODE,ANNEE,MOIS,FTP_CODE,FTP_CODE,CLI_ORIGINE
insert into #MKT_EFFEC_PREC
select 'LP',ANNEE,MOIS,PSU_CODE,FTP_CODE,sum(FAC_CA),sum(FAC_CA_PREC),0,sum(FAC_VOL),sum(FAC_VOL_PREC),0 from #LISTE_CLIENTS where CLI_ORIGINE='P'
group by PSU_CODE,ANNEE,MOIS,FTP_CODE,CLI_ORIGINE
insert into #MKT_EFFEC_PREC
select 'Groupe',ANNEE,MOIS,PSU_CODE,FTP_CODE,sum(FAC_CA),sum(FAC_CA_PREC),0,sum(FAC_VOL),sum(FAC_VOL_PREC),0 from #LISTE_CLIENTS where CLI_ORIGINE in ('P','M','N')
group by PSU_CODE,ANNEE,MOIS,PSU_CODE,CLI_ORIGINE |
Partager