Displaying 1 result from an estimated 1 matches for "value_mult".
2009 Mar 27
0
consistent segfaults in ROracle with one of the databases
...atch_nbr,
audit_date
FROM dots_audit.audit_event
WHERE table_name='VALUE_PROPERTY_MAP'),
jfsm AS
(SELECT audit_key, fund_id, fund_mult
FROM dots_audit.value_property_map WHERE property_id='%s'
UNION SELECT audit_key, value_id, value_mult
FROM dots.value_property_map WHERE property_id='%s')
SELECT DISTINCT
ev.dt - to_date('01011970','ddmmyyyy') TIMESTAMP,
jfsm.value_id VALUE,
jfsm.value_mult VM,
RANK() OVER (PARTITION BY audit_batch_nbr, value_id ORDER BY dt
DES...