• INSERT INTO [dbo].[temp]

    ([PI]

    ,[m]

    ,[Date]

    ,[TT]

    ,[A])

    VALUES

    (2800 ,4 ,'2016-11-02 22:02:42.000','P' ,10),

    (2800 ,4 ,'2016-11-02 22:03:42.000','E' ,10),

    (2800 ,4 ,'2016-11-02 22:04:42.000' ,'E' ,10),

    (2800 ,4 ,'2016-12-27 21:54:26' ,'C' ,10),

    (2800 ,4 ,'2016-12-29 10:13:24.000' ,'R' ,10),

    (2800 ,4 ,'2016-12-29 21:39:36.000' , 'C' ,10),

    (2800 ,4 ,'2017-01-03 08:34:32.000' ,'R' ,10)

    GO