var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need to know how to do division, subtraction and multiplation within an CASE WHEN statement... below is my TSQL.
CASE WHEN ColumnName IS NULL THEN 0 ELSE ((ColumnName1-ColumnName2)/ColumnName3)*100 END AS 'Alias'
what do you need help with?
you already are doing subtraction, division, and multilpication
rudy.ca | @rudydotca
Buy my SitePoint book: Simply SQL
That's correct I am. Long story short, its been solved. I was using single quotes on column names, inturn treating them as literals. Also, I wasn't sure if thats how the math was done because it kept giving me errors.
It works now though. Thanks for the reply.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors