declare @sql varchar(8000)
select @sql=''
select @sql=@sql+',max(case when rq='''+rtrim(rq)+''' and name='''+rtrim(name)+''' then time1 else '''' end) as ['+rtrim(rq)+']' from kq group by rq,nameexec ('select * from (select name'+@sql+' from kq where time1 like ''上%'' group by name union all select name'+@sql+' from kq where time1 like ''下%'' group by name)t order by name')
select @sql=''
select @sql=@sql+',max(case when rq='''+rtrim(rq)+''' and name='''+rtrim(name)+''' then time1 else '''' end) as ['+rtrim(rq)+']' from kq group by rq,nameexec ('select * from (select name'+@sql+' from kq where time1 like ''上%'' group by name union all select name'+@sql+' from kq where time1 like ''下%'' group by name)t order by name')
解决方案 »
- 安装sql server 2008 R2时出错
- sql语句解释
- SQL SERVER 2005表分区,关于分区方案的划分的问题
- Management Studio在恢复系统后无法启动,出现如下提示:(有图有真相)
- 继续 ,感谢老师 dawugui 米老鼠
- 求一个存储过程?
- 用bcp命令从文本文件中恢复sql server里的表
- distinct+排序小问题
- ASP编程中使用VBScript怎样联接SQl server 2000?
- 在数据库 'tempdb' 中拒绝了 CREATE TABLE 权限。
- 数据恢复问题,非常困难,非常感谢有能帮上忙的人
- 当程序调用sqlserver存储过程的时候,当数据量过大的时候出现常规网络错误!
declare @s1 varchar(8000)
set @s = ''
set @s1 = ''
select @s = @s + ',' + ' max(case when rq = ''' + rq + ''' then time1 end) as ''' + rq + ''''
from kq group by rq
select @s1 = @s1 + ',' + ' min(case when rq = ''' + rq + ''' then time1 end) as ''' + rq + ''''
from kq group by rqexec ( 'select name ' + @s + ' from kq group by name union all select name ' + @S1 +' from kq group by name' )