hi
i need to do this
I. Filter records where Asset Type = ‘Future-Bond’ AND/OR ‘Future-InterestRate’
II. Perform identity match on MasterIdentifer (from Holdings table) to Security ID on this file
III. Populated Holdings.NotionalAmount with MV Book Notional from Report 262
else if Asset Type does not = ‘Future-Bond’ AND/OR ‘Future-InterestRate’ populate Holdings.NotionalAmount with a different filed value
am i better doing this as an sql script