• Thanks Lynn,

    i want to insert data in below table.

    CREATE TABLE [dbo].[tblstudentPlaner](

    [PlanerID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,

    [StudID] [int] NOT NULL,

    [EffectiveDate] [datetime] NULL,

    [StartTime] [varchar](20) NULL,

    [EndTime] [varchar](20) NULL,

    [Flag] [bit] NULL,

    CONSTRAINT [PK_tblstudentPlaner] PRIMARY KEY CLUSTERED

    (

    [PlanerID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]