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.
|SQL Server Deadlocks||12||47|
|SQL Query stumper||3||36|
|How to get time difference in minutes and seconds only between 2 dates||2||16|
|Getting max record but maybe not use Group BY||2||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!