Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
taylo
Yak Posting Veteran
82 Posts |
 Posted - 2000-11-18 : 22:52:18
|
| I am trying to do this percentage thing with a Stored Procedure.This is the way I may have to do it nayway.But I can not get this stored Proc to give ma decimal number.Update tblData Set VotePercent = (Votes/(Select Count(Votes) from tblData2))But in gives me a whole number and not a decimal. I have the right type on the dabase field. Do I need to declare a data type here?Thanks,Rob |
|
|
|
|
|
Rob