Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
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.
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!