已经转成行了..现在想把行转成列...
转成行的SQL
select t.licName taName, t.licNo licNo, t.turn turn,t.year year
from(
select (lic.E_LICENSEE +' '+ lic.C_LICENSEE)licName,lic.LIC_NO licNo,
(CAST(lmt.MAINLAND_YEAR AS varchar(20)) + '01') as year, lmt.JAN as turn
from LICENCE lic, LICENCE_MAINLAND_TOUR lmt
where lic.LIC_NO = lmt.LIC_NO
union all
select (lic.E_LICENSEE +' '+ lic.C_LICENSEE)licName,lic.LIC_NO licNo,
(CAST(lmt.MAINLAND_YEAR AS varchar(20)) + '02') as year, lmt.FEB as turn
from LICENCE lic, LICENCE_MAINLAND_TOUR lmt
where lic.LIC_NO = lmt.LIC_NO
union all
select (lic.E_LICENSEE +' '+ lic.C_LICENSEE)licName,lic.LIC_NO licNo,
(CAST(lmt.MAINLAND_YEAR AS varchar(20)) + '03') as year, lmt.MAR as turn
from LICENCE lic, LICENCE_MAINLAND_TOUR lmt
where lic.LIC_NO = lmt.LIC_NO
union all
select (lic.E_LICENSEE +' '+ lic.C_LICENSEE)licName,lic.LIC_NO licNo,
(CAST(lmt.MAINLAND_YEAR AS varchar(20)) + '04') as year, lmt.APR as turn
from LICENCE lic, LICENCE_MAINLAND_TOUR lmt
where lic.LIC_NO = lmt.LIC_NO
union all
select (lic.E_LICENSEE +' '+ lic.C_LICENSEE)licName,lic.LIC_NO licNo,
(CAST(lmt.MAINLAND_YEAR AS varchar(20)) + '05') as year, lmt.MAY as turn
from LICENCE lic, L
以前一直使用从网上找的一个分页存储过程，一直以来记录不多，没发现什么问题，最近有张比较复杂的表，且需要多表查询，数据量大概近1万，突然发现在前100页速度还可以，但是200页以后速度特别慢....
求一个� ......
