Home Forums SQL Server 2014 Development - SQL Server 2014 need help to write a query RE: need help to write a query

  • February 8, 2016 at 11:57 am

    #1857206

    USE [rptdev]

    GO

    /****** Object: Table [dbo].[TBRTEK002] Script Date: 2/8/2016 1:56:36 PM ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_PADDING ON

    GO

    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

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    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)))

    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'3 ', CAST(0.00 AS Decimal(18, 2)))

    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'2 ', CAST(0.00 AS Decimal(18, 2)))

    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'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E01 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E02 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E03 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E04 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'E05 ', N'SA1915', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(17.96 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(17.96 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F01 ', N'101006', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(15.90 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(24.76 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(24.70 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(24.76 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(24.40 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(16.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.05 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(16.05 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(16.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(15.75 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.01 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.01 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(15.89 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(16.01 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(16.16 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(16.16 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F06 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(15.97 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(15.96 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(15.96 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(15.83 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(15.96 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F09 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F10 ', N'101015', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(16.90 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F11 ', N'103008', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(21.70 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(21.10 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'F13 ', N'101022', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV01 ', N'101005', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV02 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV03 ', N'101003', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV05 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV07 ', N'101012', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'FV12 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P01 ', N'101005', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P02 ', N'101017', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P03 ', N'101004', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P04 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P05 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P07 ', N'101026', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101001', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-12 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'4 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'3 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'2 ', CAST(0.00 AS Decimal(18, 2)))

    GO

    INSERT [dbo].[TBRTEK002] ([t_mcno], [t_citg], [t_trdt], [t_shft], [t_wght]) VALUES (N'P08 ', N'101002', CAST(N'2016-01-11 00:00:00.000' AS DateTime), N'1 ', CAST(0.00 AS Decimal(18, 2)))

    GO