Hi
Try this script below
ALTER proc [dbo].[anketOySonuc]
(
@anketId int
)
as
Declare @totalCount int;
SET @totalCount=0;
select @totalCount=count(AnketSiklari.AnketSikAdi)
from aaaaa inner join
AnketSiklari
on AnketSiklari.AnketSiklariID=aaaaa.AnketSiklariID
where aaaaa.AnketId=@anketId
select AnketSiklari.AnketSikAdi,ISNULL((count(aaaaa.AnketSiklariID)*100)/@totalCount,0) 'Verilen Oy Sayısı'
from aaaaa inner join
AnketSiklari
on AnketSiklari.AnketSiklariID=aaaaa.AnketSiklariID
where aaaaa.AnketId=@anketId
group by AnketSikAdi ;
Hope this will help.