469,076 Members | 1,305 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

decimal problem... help please

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


21 62.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

21 62

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

Thanks in advance.
Nov 6 '06 #1
2 1326
143 100+
create table #Influence (Playerid decimal(5), InfluenceValue float(5,6))
Nov 6 '06 #2
thank you very much..
Nov 7 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

21 posts views Thread by Batista, Facundo | last post: by
4 posts views Thread by Yodai | last post: by
2 posts views Thread by Steve Summit | last post: by
1 post views Thread by ven | last post: by
11 posts views Thread by MikeY | last post: by
reply views Thread by Terry Reedy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.