Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rjhe22

    bloomberg issue

    i have this code CR1 == "nr"? BLLOMBERG_RTG_mOODYS == "bAA3"?BBN :CR1 :CR1 so if cr1 = nr and bllomberg has a value == baa3 then it retuns the bbn or nr in my line it has the bba3 in the moodys column and the nr in the cr1 coulmn but its still pulling the nr value anyone no why
  2. rjhe22

    datetime field

    thses are the erros TITLE: Microsoft Visual Studio ------------------------------ Error at Categorization [Derived Column [27562]]: Error code 0x80040E21 occurred attempting to convert from data type DT_WSTR to data type DT_DBTIMESTAMP2. Error at Categorization [Derived Column [27562]]...
  3. rjhe22

    datetime field

    hi i have this code that does not seem to work with datetime fields in my expression can anyone tell me what i have to do to get it to work ISNULL(BLOOM_ISSUE_DT) ? "1900-01-01" : UPPER(TRIM(BLOOM_ISSUE_DT))
  4. rjhe22

    truncation error

    hi have a derived column with this in it BLOOM_COUNTRY != "" ? "BLOOMBERG" + BLOOM_COUNTRY : CO1 before that i have a dervided column that set co1= ISS_NAME a field in the table im getting the following error [Country [22353]] Error: The "component "Country" (22353)" failed because truncation...
  5. rjhe22

    expression

    thanks for the help
  6. rjhe22

    another expression im stuck with

    if RTG_SP = AA+ and RTG_MOODY = Aa3 the load code is AAP how do i wirte this does anyone know
  7. rjhe22

    expression

    he i need to right this as an expression in a drived column anyone no how to do it ‘BLOOMBERG’ + BLOOMBERG COUNTRY FOR not empty BLOOMBERG COUNTRY else ISS_COUNTRY i have the first part done "BLOOMBERG" + BLOOM_COUNTRY just dont no how to finish it of

Part and Inventory Search

Back
Top