sqlserver 先转行后转列

已经转成行了..现在想把行转成列...
转成行的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