|
esthera
Flowing Fount of Yak Knowledge
1340 Posts |
 Posted - 02/25/2013 : 02:35:27
|
I am doing
declare @temp money,
@numdays int
select @numdays=35
select @temp=@numdays/30
select @temp as temp
it's returning 1 but it should return 1.1666
what do I need to do to return it as a money or float?
num days will always be a integer but dividing it by 30 should not
|
|
dividing money by int is returning an int
