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