Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if {ACCOUNT_INFO.InstitutionIdentifier}="TPOCFBOI" then 1.10 else
- if {ACCOUNT_INFO.InstitutionIdentifier}="TPOBCB"then 0.50 else
- if {ACCOUNT_INFO.InstitutionIdentifier}="TPOCFB"then 0.75 else
- if {INSTITUTION.Region}="WMG" then .01 else
- if {vAM_CRG_LOAN_OFFICER_NAME.LoanOfficerName} ="Margaret S. Smith"
- then .875
- What would the code look like in a Sql View to produce a decimal (3
- places)?
- I tried
- DECLARE
- @LO_Individual_Comp DECIMAL(18,3),
- BEGIN
- SELECT description INTO LO_Individual_Comp
- FROM {ACCOUNT_INFO}
- WHERE InstitutionIdentifier} = "TPOCFBOI";
- DBMS_OUTPUT.PUT_LINE('1.10' || LO_Individual_Comp;
- END;
- If > Then Sql Equivalent to return a decimal (3 places)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement