SHARE
TWEET

Untitled

a guest Jun 25th, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. if {ACCOUNT_INFO.InstitutionIdentifier}="TPOCFBOI" then 1.10 else
  2.      if {ACCOUNT_INFO.InstitutionIdentifier}="TPOBCB"then 0.50 else
  3.      if {ACCOUNT_INFO.InstitutionIdentifier}="TPOCFB"then 0.75 else
  4.      if {INSTITUTION.Region}="WMG" then .01 else
  5.       if {vAM_CRG_LOAN_OFFICER_NAME.LoanOfficerName} ="Margaret S. Smith"
  6.      then .875
  7.  
  8.       What would the code look like in a Sql View to produce a decimal (3
  9.       places)?
  10.  
  11.  
  12.  
  13.  
  14.  
  15.        I tried
  16.  
  17.     DECLARE
  18.        @LO_Individual_Comp DECIMAL(18,3),
  19.      BEGIN
  20.      SELECT description INTO LO_Individual_Comp
  21.       FROM {ACCOUNT_INFO}
  22.       WHERE InstitutionIdentifier} = "TPOCFBOI";
  23.        DBMS_OUTPUT.PUT_LINE('1.10' || LO_Individual_Comp;
  24.       END;
  25.  
  26.        If > Then Sql Equivalent to return a decimal (3 places)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top