Wednesday, March 7, 2012

decimal problem... help please

1. SQL
select #InfluencePlayerID.playerid, #InfluenceValue.influencevalue
from #InfluencePlayerID, #InfluenceValue

OUTPUT

2162.052204

2. SQL
create table #Influence (Playerid decimal(5), InfluenceValue decimal(5))

insert into #Influence
select #InfluencePlayerID.playerid, #InfluenceValue.influencevalue
from #InfluencePlayerID, #InfluenceValue

select *
from #influence

OUTPUT
2162

Why does it give the output as a whole number????

Thanks in advance.
Mehulcreate table #Influence (Playerid decimal(5), InfluenceValue float(5,6))|||thank you very much..

No comments:

Post a Comment