Post reply

populating 1 column from 2 different columns

  • August 5, 2014 at 5:09 am

    #289408

    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

  • August 5, 2014 at 8:37 am

    #1735231

    Please post DDL and sample data as insert statements so we can have something to test on. You should post expected results based on that sample data.

    Otherwise, I'm not sure you'll get good responses.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply