SQL行转列

create table #tTemp
(
  iID                int IDENTITY,
  cTechParaName      varchar(64) null,       
  cTechParaName2       varchar(64) NULL,  
  iSerial      varchar(32)              
)
insert into #tTemp(cTechParaName,cTechParaName2,iSerial)
select cTechParaName,isnull(cTechParaName2,cTechParaName) as cTechParaName2,iSerial 
 from tEqaTechParaDefine where cEquiSortCode='0001' order by iSerial
select cTechParaName,isnull(cTechParaName2,cTechParaName) as cTechParaName2,iSerial 
 from tEqaTechParaDefine where cEquiSortCode='0001' order by iSerial

create table #tColumn_Temp
(
  iID          int,    
)
insert into #tColumn_Temp(iID) values(1)
insert into #tColumn_Temp(iID) values(2)
declare @iCount int,@i int,@cTechParaName varchar(64),@cTechParaName2 varchar(64),@strSql varchar(6000),@strColumn varchar(32)
select @iCount = COUNT(1) from #tTemp
select @i=1,@cTechParaName = '' ,@cTechParaName2='', @strColumn=''
while @i <= @iCount
begin
        select @cTechParaName = cTechParaName,@cTechParaName2 = cTechParaName2 from #tTemp where iID = @i
        set @strColumn = rtrim(ltrim(STR(@i)))
        exec('alter table #tColumn_Temp add ['+  @strColumn +'] varchar(64) null ') 
        
        
         SET @strSql = 'update #tColumn_Temp set [' + @strColumn + '] = ''' + @cTechParaName  + ''' where iID = 1'
        exec(@strSql)
        
        SET @strSql = 'update #tColumn_Temp set [' + @strColumn+ '] = ''' + @cTechParaName2  + ''' where iID = 2'
        exec(@strSql)
      
        set @i = @i +1
end

select * from #tColumn_Temp
drop table #tColumn_Temp
drop table #tTemp

南来地,北往的,上班的,下岗的,走过路过不要错过!

======================个性签名=====================

之前认为Apple 的iOS 设计的要比 Android 稳定,我错了吗?

下载的许多客户端程序/游戏程序,经常会Crash,是程序写的不好(内存泄漏?刚启动也会吗?)还是iOS本身的不稳定!!!

如果在Android手机中可以简单联接到ddms,就可以查看系统log,很容易看到程序为什么出错,在iPhone中如何得知呢?试试Organizer吧,分析一下Device logs,也许有用.

我的开发工具