declare @sql varchar(8000)
set @sql = 'select user_Id' select @sql = @sql +', sum(case sort when ''' + sort + ''' then 1 else 0 end) as [' + sort + '(次)]'
from (select distinct sort from clocking) xset @sql = @sql + ' from clocking group by user_Id order by user_Id'exec (@sql)
set @sql = 'select user_Id' select @sql = @sql +', sum(case sort when ''' + sort + ''' then 1 else 0 end) as [' + sort + '(次)]'
from (select distinct sort from clocking) xset @sql = @sql + ' from clocking group by user_Id order by user_Id'exec (@sql)
解决方案 »
- 高手进!
- asp.net 1.1中在代码隐藏模块中,怎么使用Request,Response,Server,Session,Application对象?
- 今年未决的最后一个问题??
- 怎样给TreeView动态的添加节点(在数据库中)
- 如何写一个表单页面,使用户提交表单后直接将内容发至指定邮箱
- 如何配制IIS6.0?客户端访问我的机子会弹出窗体让输入用户名和密码。Web.config中使用的是Form验证。
- 求电子支付的实现方法或过程
- ASP。NET程序 可不可以调用ASP组件?
- 请教问题,各位大哥帮忙!谢谢
- linq to sql语句AddTime <= DateTime.Now
- 无法从控制 Socket 读取。Socket 错误 = #10054
- 求一个sql语句!
from (select distinct sort from clocking) x
order by sort descset @sql = @sql + ' from clocking group by user_Id order by user_Id'exec (@sql)