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 strongm 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: *

  • Users: l610d42s
  • Order by date
  1. l610d42s

    update and correlated subquery

    Just to add. I did not check your SELECT clause but I think if ur SELECT query is fine then the solution i have suggested should work,although I haven't tested it.
  2. l610d42s

    update and correlated subquery

    Hi Buddy, U can try the following. I have just changed the way you were updating. update OLAPV2_DB.TO_L59_SUSP_BAL_AMT FROM (sel balance_amt as amt from pmdbivm_prd.coll_balance_hist where acct_id = OLAPV2_DB.TO_L59_SUSP_BAL_AMT.acct_id and (acct_id, eff_dt) in (sel...

Part and Inventory Search

Back
Top