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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
update #TbmResults
set FNDCSR_IDp301SurPerf =
CASE
WHEN TbmRe.FNDCSR_IDp301Perf = -100000 THEN -100000
WHEN FNDOUTidp301.resultFloat = -100000 THEN -100000
ELSE TbmRe.FNDCSR_IDp301Perf - FNDOUTidp301.resultFloat END,
FNDCSR_IDp303SurPerf =
CASE
WHEN TbmRe.FNDCSR_IDp303Perf = -100000 THEN -100000
WHEN FNDOUTidp303.resultFloat = -100000 THEN -100000
ELSE TbmRe.FNDCSR_IDp303Perf - FNDOUTidp303.resultFloat END,
FNDCSR_IDp305SurPerf =
CASE
WHEN TbmRe.FNDCSR_IDp305Perf = -100000 THEN -100000
WHEN FNDOUTidp305.resultFloat = -100000 THEN -100000
ELSE TbmRe.FNDCSR_IDp305Perf - FNDOUTidp305.resultFloat END,
FNDCSR_IDp10SurPerf =
CASE
WHEN TbmRe.FNDCSR_IDp10Perf = -100000 THEN -100000
WHEN FNDOUTidp10.resultFloat = -100000 THEN -100000
ELSE TbmRe.FNDCSR_IDp10Perf - FNDOUTidp10.resultFloat END
from #TbmResults TbmRe,
#FND_CSROut FNDOUTidp301, #FND_PARAM FNDPAidp301,
#FND_CSROut FNDOUTidp303, #FND_PARAM FNDPAidp303,
#FND_CSROut FNDOUTidp305, #FND_PARAM FNDPAidp305,
#FND_CSROut FNDOUTidp10, #FND_PARAM FNDPAidp10
where FNDPAidp301.id_periode = 301
and FNDPAidp303.id_periode = 303
and FNDPAidp305.id_periode = 305
and FNDPAidp10.id_periode = 10
and FNDPAidp301.id_param = FNDOUTidp301.id_param
and FNDPAidp303.id_param = FNDOUTidp303.id_param
and FNDPAidp305.id_param = FNDOUTidp305.id_param
and FNDPAidp10.id_param = FNDOUTidp10.id_param
and TbmRe.id_fondsIRP = FNDPAidp301.id_fonds
and TbmRe.id_fondsIRP = FNDPAidp303.id_fonds
and TbmRe.id_fondsIRP = FNDPAidp305.id_fonds
and TbmRe.id_fondsIRP = FNDPAidp10.id_fonds
creation des index sur la colonne id_periode de la table #FND_PARAM
sur la colonne id_param des tables #FND_PARAM et #FND_CSROut
sur la colonne id_fonds des tables #FND_PARAM et #TbmResults |
Partager