1 2 3 4 5 6 7 8 9 10 11 12
|
UPDATE BAFI_criteria
SET
GRANULN139 = Iif([pmusrisu.TrancheGranularity] > 6,"Y","N"),
FRQCOTN157 = UCase( Left(pmusrisu.QuotationFrequency, 1)),
INDICN084 = Left(pmusrisu.Index,20), OPCVELIN087 = pmusrisu.UCITS,
TITLIQN082 = pmusrisu.LiquidSecurity,
RANGTITRN081 = pmusrisu.TrancheSeniorityRank,
TITRCOTN156 = pmusrisu.QuotedSecurity,
PLAQOT = Iif(Val(pmusrisu.QuotationPlace) =0,499,Val(Left(pmusrisu.QuotationPlace, 3)))
FROM BAFI_criteria INNER JOIN pmusrisu
ON BAFI_criteria.Cusip = pmusrisu.Cusip; |
Partager