February 8, 2016 at 10:44 am
Hello all,
This is my table and records.
Mcno ItemNo Date shft gram
F03 1010042016-01-12 424.76
F03 1010042016-01-12 30.00
F03 1010042016-01-12 20.00
F03 1010042016-01-12 124.70
F03 1010042016-01-11 424.76
F03 1010042016-01-11 30.00
F03 1010042016-01-11 224.40
I am looking for below result. I am looking gram that should be previous shift as mention below. Pleas help me to write query.
F03 1010042016-01-12 424.76
F03 1010042016-01-12 324.70
F03 1010042016-01-12 224.70
F03 1010042016-01-12 124.70
F03 1010042016-01-11 424.76
F03 1010042016-01-11 324.40
F03 1010042016-01-11 224.40
February 8, 2016 at 11:34 am
as previously mentioned to you...please provide scripts...thanks
http://www.sqlservercentral.com/Forums/FindPost1756729.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 11:57 am
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
February 8, 2016 at 12:29 pm
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
February 8, 2016 at 12:31 pm
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(18.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(14.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(15.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
February 8, 2016 at 12:37 pm
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];
February 8, 2016 at 12:52 pm
As I mention,
Mcno ItemNo Date shft gram
F03 1010042016-01-12424.76
F03 1010042016-01-1230.00
F03 1010042016-01-1220.00
F03 1010042016-01-12124.70
F03 1010042016-01-11424.76
F03 1010042016-01-1130.00
F03 1010042016-01-11224.40
F03 1010042016-01-11224.40
F02 1010042016-01-11424.40
F02 1010042016-01-11324.40
F02 1010042016-01-11200.00
F02 1010042016-01-11100.00
I am looking for below result. I am looking gram that should be previous shift as mention below. Pleas help me to write query.
I am looking last column that should pick up previous value if exist.
F03 1010042016-01-12424.76
F03 1010042016-01-12324.70
F03 1010042016-01-12224.70
F03 1010042016-01-12124.70
F03 1010042016-01-11424.76
F03 1010042016-01-11324.40
F03 1010042016-01-11224.40
F03 1010042016-01-11224.40
F03 1010042016-01-11224.40
F03 1010042016-01-11224.40
F03 1010042016-01-11200.00
F03 1010042016-01-11200.00
February 8, 2016 at 1:26 pm
if I run the sample scripts and then run this query
SELECT t_mcno, t_citg, t_trdt, t_shft, t_wght
FROM TBRTEK002
WHERE (t_mcno = 'F03')
ORDER BY t_trdt desc, t_shft desc
I get the following
+-------------------------------------------------------------+
¦ t_mcno ¦ t_citg ¦ t_trdt ¦ t_shft ¦ t_wght ¦
¦--------+--------+-------------------------+--------+--------¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 4 ¦ 24.76 ¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 3 ¦ 0.00 ¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 2 ¦ 0.00 ¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 1 ¦ 24.70 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 4 ¦ 24.76 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 3 ¦ 0.00 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 2 ¦ 24.40 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 1 ¦ 0.00 ¦
+-------------------------------------------------------------+
cant follow your logic for your expected results.....?? can you explain
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
February 8, 2016 at 1:27 pm
+-------------------------------------------------------------+
¦ t_mcno ¦ t_citg ¦ t_trdt ¦ t_shft ¦ t_wght ¦
¦--------+--------+-------------------------+--------+--------¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 4 ¦ 24.76 ¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 3 ¦ 24.70 ¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 2 ¦ 24.70 ¦
¦ F03 ¦ 101004 ¦ 2016-01-12 00:00:00.000 ¦ 1 ¦ 24.70 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 4 ¦ 24.76 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 3 ¦ 24.40 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 2 ¦ 24.40 ¦
¦ F03 ¦ 101004 ¦ 2016-01-11 00:00:00.000 ¦ 1 ¦ 0.00 ¦
+-------------------------------------------------------------+
February 8, 2016 at 1:28 pm
above result I am expected.
Thank you.
February 8, 2016 at 1:36 pm
One way to do it. Assuming I understand correctly.
SELECT *,
COALESCE( NULLIF( t_wght, 0),
NULLIF( LAG(t_wght,1) OVER( PARTITION BY t_mcno, t_citg, t_trdt ORDER BY t_shft), 0),
NULLIF( LAG(t_wght,2) OVER( PARTITION BY t_mcno, t_citg, t_trdt ORDER BY t_shft), 0),
NULLIF( LAG(t_wght,3) OVER( PARTITION BY t_mcno, t_citg, t_trdt ORDER BY t_shft), 0), 0)
FROM [TBRTEK002]
WHERE t_mcno = 'F03'
ORDER BY t_trdt desc, t_shft desc;
February 8, 2016 at 1:39 pm
I am using 2008 R2 and I am not able to run above query. I am sorry.
February 8, 2016 at 1:44 pm
patla4u (2/8/2016)
I am using 2008 R2 and I am not able to run above query. I am sorry.
And why do you post in the 2014 forum? :angry:
February 8, 2016 at 1:47 pm
Sorry.. I have 2014. but server is2008 R2.
February 8, 2016 at 1:49 pm
Here's a 2008 friendly option.
SELECT o.*,
COALESCE( NULLIF( o.t_wght, 0), x.t_wght, 0)
FROM [TBRTEK002] o
OUTER APPLY (
SELECT TOP 1 i.t_wght
FROM [TBRTEK002] i
WHERE i.t_mcno = o.t_mcno
AND i.t_citg = o.t_citg
AND i.t_trdt = o.t_trdt
AND i.t_shft < o.t_shft
AND i.t_wght > 0
ORDER BY i.t_shft DESC
) x
WHERE o.t_mcno = 'F03'
ORDER BY t_trdt desc, t_shft desc;
Viewing 15 posts - 1 through 15 (of 25 total)
You must be logged in to reply to this topic. Login to reply