Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
First: Cast(CAST(e.currentintrate as varchar(20))* CAST(e.currentprinbal as varchar(20)) * (30))/((360)*(100))) as VARCHAR(50)) as AINTINC, Msg 1035, Level 15, State 10, Line 22 Incorrect syntax near 'Cast', expected 'AS'. Second: convert(varchar, Cast((AINTRATE*AAVGBALA*(30))/((360)*(100)) as money)) as AINTINC, Msg 8117, Level 16, State 1, Line 9 Operand data type varchar is invalid for multiply operator.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.