sql 创建动态视图，动态列

1 第一步(生成时区表)
USE [Elian]
GO
/****** 对象:  Table [dbo].[G_LessonTimeZone]    脚本日期: 09/02/2008 11:46:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[G_LessonTimeZone](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [lessonid] [int] NOT NULL,
    [LessonStartTimeZoneEast1] [datetime] NULL,
    [LessonStartTimeZoneEast2] [datetime] NULL,
    [LessonStartTimeZoneEast3] [datetime] NULL,
    [LessonStartTimeZoneEast4] [datetime] NULL,
    [LessonStartTimeZoneEast5] [datetime] NULL,
    [LessonStartTimeZoneEast6] [datetime] NULL,
    [LessonStartTimeZoneEast7] [datetime] NULL,
    [LessonStartTimeZoneEast8] [datetime] NULL,
    [LessonStartTimeZoneEast9] [datetime] NULL,
    [LessonStartTimeZoneEast10] [datetime] NULL,
    [LessonStartTimeZoneEast11] [datetime] NULL,
    [LessonStartTimeZoneEast12] [datetime] NULL,
    [LessonStartTimeZoneWest1] [datetime] NULL,
    [LessonStartTimeZoneWest2] [datetime] NULL,
    [LessonStartTimeZoneWest3] [datetime] NULL,
    [LessonStartTimeZoneWest4] [datetime] NULL,
    [LessonStartTimeZoneWest5] [datetime] NULL,
    [LessonStartTimeZoneWest6] [datetime]