need help to write a query

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 10:44 am

  #311321

  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

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  February 8, 2016 at 11:34 am

  #1857200

  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

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 11:57 am

  #1857206

  USE [rptdev]

  GO

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

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[TBRTEK002](

  [t_mcno] [char](6) NULL,

  [t_citg] [char](6) NULL,

  [t_trdt] [datetime] NULL,

  [t_shft] [char](3) NULL,

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

  ) ON [PRIMARY]

  GO

  SET ANSI_PADDING OFF

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 12:29 pm

  #1857219

  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

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 12:31 pm

  #1857220

  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

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  February 8, 2016 at 12:37 pm

  #1857221

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

  CREATE TABLE [dbo].[TBRTEK002](

  [t_mcno] [char](6) NULL,

  [t_citg] [char](6) NULL,

  [t_trdt] [datetime] NULL,

  [t_shft] [char](3) NULL,

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

  );

  GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  SELECT * FROM [TBRTEK002];

  GO

  DROP TABLE [TBRTEK002];

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

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

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 12:52 pm

  #1857225

  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

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  February 8, 2016 at 1:26 pm

  #1857232

  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

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 1:27 pm

  #1857233

  +-------------------------------------------------------------+

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

  +-------------------------------------------------------------+

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 1:28 pm

  #1857234

  above result I am expected.

  Thank you.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  February 8, 2016 at 1:36 pm

  #1857235

  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;

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

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

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 1:39 pm

  #1857237

  I am using 2008 R2 and I am not able to run above query. I am sorry.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  February 8, 2016 at 1:44 pm

  #1857238

  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:

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

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

• patla4u

  SSCrazy

  Points: 2103

  More actions

  February 8, 2016 at 1:47 pm

  #1857240

  Sorry.. I have 2014. but server is2008 R2.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  February 8, 2016 at 1:49 pm

  #1857241

  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;

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

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