想要按百分比显示qsurvey [英] İ wanna show the qsurvey by percent

问题描述

ALTER proc [dbo].[anketOySonuc] 
( 
@anketId int 
) 
as 
select AnketSiklari.AnketSikAdi,count(aaaaa.AnketSiklariID)''Verilen Oy Sayısı'' from aaaaa inner join AnketSiklari on AnketSiklari.AnketSiklariID=aaaaa.AnketSiklariID where aaaaa.AnketId=@anketId group by AnketSikAdi 

此sp视图

this sp view

AnketSikAdi    Verilen Oy Sayısı 
26-35             1 
36-...            1

我该怎么做

how can ı do this

AnketSikAdi    Verilen Oy Sayısı 
26-35             %50 
36-...             %50

[edit]已添加代码块，忽略HTML ..."选项已禁用-OriginalGriff [/edit]

[edit]Code blocks added, "Ignore HTML..." option disabled - OriginalGriff[/edit]

推荐答案

嗨
在下面尝试此脚本

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.

这篇关于想要按百分比显示qsurvey的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！