Decimal Points

[krotha]

Hi
I have small question.
If I select at my query analyzer
select 1030/100 results 10. But I want upto two decimals(10.30) How shall I do.

Thanks For your help.

 

[balves]

Depending on what you're trying to do:

select convert(decimal(4,0),1030) /convert(decimal(4,0),100)

or

select convert(decimal(6,2), 1030.0 /100.0)

 

[krotha]

Thanks It helps. Based on this I will modify my query.

Thanks a lot