Viewing post 1 (of 1 total)
Hi
Select
Income,
Expense,
(
(Cast(Income as Float) - Cast(Expense as Float)) / Cast( ISNULL(NULLIF(Income,0),1) as Float)
) * 100 As percentageexpense
FROM
select income =4, expense =3
union all
select income...
November 21, 2007 at 6:37 am
#753071