this query is working perfectly in access. i created the table same structure in sql server 2005 and it wont show the percentages. it says 0 as results
SELECT TOP 6 Count(vote.voteid) AS ['Count Of Teams'], racerinfo.racername, (((Count(vote.voteid))/(select count(voteid) from vote))*100) AS TotalPercentage
FROM vote, racerinfo
GROUP BY racerinfo.racername, vote.voteid
ORDER BY Count(vote.voteid) DESC
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.