• You provided 276 rows of data. Are you expecting people to check correctness for all those rows? What would be the expected results?

    CREATE TABLE [dbo].[TBRTEK002](

    [t_mcno] [char](6) NULL,

    [t_citg] [char](6) NULL,

    [t_trdt] [datetime] NULL,

    [t_shft] [char](3) NULL,

    [t_wght] [decimal](18, 2) NULL

    );

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght])

    VALUES (N'E01 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(17.96 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(17.96 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(15.90 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(24.76 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(24.70 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(24.76 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(24.40 AS Decimal(18, 2)))

    ,(N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(16.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.05 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(16.05 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(16.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(15.75 AS Decimal(18, 2)))

    ,(N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.01 AS Decimal(18, 2)))

    ,(N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.01 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(15.89 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(16.01 AS Decimal(18, 2)))

    ,(N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.16 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(16.16 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(15.97 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(15.96 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(15.96 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(15.83 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(15.96 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(16.90 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(21.70 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(21.10 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    ,(N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)));

    SELECT * FROM [TBRTEK002];

    GO

    DROP TABLE [TBRTEK002];

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2