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];