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

OUTPUT

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

OUTPUT
21 62


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

Thanks in advance.
Mehul
Nov 6 '06 #1
2 1326
scripto
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.