vigneshkumart50 (5/7/2014)
Hi,I have these two columns
select
'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)as MONEY),1), '.00', '') as Total_Amount,
'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Monthly_Amount,2)as MONEY),1), '.00', '') as Monthly_Amount
from Finance
Now Monthly_Amount column should have calculated values like Total_Amount/12
Is this what you are after?
😎
select
'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)as MONEY),1), '.00', '') as Total_Amount,
'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round(Total_Amount,2)as MONEY) / 12,1), '.00', '') as Monthly_Amount
from Finance