Create procedure staticByUser @username varchar(20),@flag varchar(10)
as
//1.总分
if @flag='zengfen'
select sum(INT) from a
//2....
//3...
as
//1.总分
if @flag='zengfen'
select sum(INT) from a
//2....
//3...
解决方案 »
- 如何让父进度等于子进度的累加
- C# radiobutton 状态的问题
- 有谁写过类似word显示比例控件的程序?
- |M| AjaxPro为什么没办法返回DataSet 我照网上的做为什么怎么也不行
- System.Net 发邮件验证时遇到问题
- 走过路过不要错过,求助JS!!!
- HTML控件写的提交页面可否用ASPX的CS程序获取值?急!
- ????看看
- (最后的家产)DataGrid控件点击删除时,如何通过弹出对话框“是,否”来确实是否删除记录
- 发布到服务器后出现以下问题,刷新地址栏后又恢复正常了。。。
- 以前是做B/S项目的,现在公司要我负责带领几个人做一个大型网站,求经验人干指点。
- 紧急支援--谢谢
P.answerCount,Q.answerokCount,R.answerokRate,
S.questionCount,T.questionokCount,U.questioningCount
from (
select name,int from a where name='@name') M
left join (
select sum(int) as int,name from(
select answerTB.name,questionTB.int from c as answerTB,b as questionTB where answerTB.questionid=questionTB.id
) group by name
) N on M.name=N.name
left join (
select name,sum(int) as int where isok='1' group by name
) O on M.name = O.name
left join (
select count(1) as answerCount,name from c group by name
) P on M.name=P.name
left join(
select select count(1) as answerokCount,name from c where questionid in (select id from b where isok='1') group by name
) Q on M.name=Q.name
left join(
select (a.answerokCount*100)/b.answerokCount as answerokRate,name from (select count(1) as answerokCount,name from c where questionid in (select id from b where isok='1') group by name) a ,(select count(1) as answerokCount,name from c) b
) R on M.name=R.name
left join (
select count(1) as questionCount,name from b group by name
) S on M.name=S.name
left join (
select count(1) as questionokCount,name from b where isok='1' group by name
) T on M.name=T.name
left join (
select count(1) as questioningCount,name from b where isok='0' group by name
) U on M.name=U.name