Grouping , time difference in minutes

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  October 19, 2021 at 4:16 pm

  #3942059

  Hi,

  I'm trying to query the amount of minutes a column value stays below a threshold and then group it together

  Im Selecting records with  Values <= 20 and then use DATEDIFF(MINUTE, [Datetime1]  to return the time difference in minutes when the first record met the <=20 threshold and then went above that threshold.  Im not sure if I should do a sub query for the time or how to go about this - thanks!

  SELECT [datetime] 
       ,[tonsperhour] 
      --,DATEDIFF(MINUTE, [datetime], [datetime]) AS [ Minutes]
  FROM [dbo].[tons_per_hour]
    where whsecd =211
    and type in (' A','B')
    and  [datetime] >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
   group by datetime, tonsperhour     
   having tonsperhour <= 20

  

  Looking  for this simple output.

  

   

• Steve Collins

  SSCommitted

  Points: 1686

  More actions

  October 19, 2021 at 5:45 pm

  #3942087

  Hi Joel, maybe something like this.  It's pretty self-explanatory once you run it

  drop table if exists #foo;
  go
  create table #foo(
    [datetime]    datetime,
    tonsperhour   float);
  
  Insert into #foo values
  (getdate(), 10.2),
  (dateadd(minute, 4, getdate()), 4.05),
  (dateadd(minute, 5, getdate()), 4.3),
  (dateadd(minute, 7, getdate()), 5.07),
  (dateadd(minute, 14, getdate()), 5.111),
  (dateadd(minute, 23, getdate()), 6.28),
  (dateadd(minute, 32, getdate()), 2.76),
  (dateadd(minute, 45, getdate()), 8.0385);
  
  /* show the SUM OVER divided by 20 */
  with
  sum_cte as (
      select *, sum(tonsperhour) over (order by [datetime]) sum_over_tph
      from #foo)
  select *,  sum_over_tph/20 calc_20_tph
  from sum_cte
  order by 1;
  
  /* GROUP BY the FLOOR of the SUM OVER divided by 20 */
  with
  sum_cte as (
      select *, sum(tonsperhour) over (order by [datetime]) sum_over_tph
      from #foo)
  select floor(sum_over_tph/20) time_grp, 
         min([datetime]) min_dt, max([datetime]) max_dt,
         count(*) row_count, sum(tonsperhour) sum_tph,
         datediff(minute, min([datetime]), max([datetime])) [Minutes Down]
  from sum_cte
  group by floor(sum_over_tph/20)
  order by 1;

  Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  October 20, 2021 at 2:10 pm

  #3942445

  Steve,  wow - thank you - That works !   would not have figured that one out, but learning all the time.

  -Thanks.

• October 27, 2021 at 1:46 pm

  This was removed by the editor as SPAM

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  November 10, 2021 at 7:35 pm

  #3950062

  Steve,

  I've been using the script you helped me with above. and its been working well, however every now and then it throws an anomaly . seems to duplicate a record depending on the date range provided. I'm not sure if its related to simple date issue or something else

  I'm using a variable  for datetime as per below.

  declare @start datetime
  declare @end datetime
  declare @type varchar
  set @start = '2021-11-07 00:00:00.000'
  set @end = '2021-11-11 23:59:00.000'
  set @type = 'Raw Sand A'
  
  ;with
  sum_cte as (
  
      select *, sum(tonsperhour) over (order by [datetime]) sum_over_tph
       FROM [dbo].[tons_per_hour]
  	   where whsecd in ('211','210')
   and meshtype in ('Raw Sand B')
   and  [datetime] between @start and @end
   )
  select floor(sum_over_tph/20) time_grp, DATEPART (d, datetime) AS Day,
  DATEPART (m, datetime) AS Month,
         min([datetime]) min_dt, max([datetime]) max_dt,
         count(*) row_count, sum(tonsperhour) sum_tph,
         datediff(minute, min([datetime]), max([datetime])) [Minutes Down],
  	   	   Case when Meshtype = 'Raw Sand A' then 'Dryer A'
  	   when Meshtype = 'Raw Sand B' then 'Dryer B'
  	   when Meshtype = 'Washed Sand A' then 'Line A'
  	   when Meshtype = 'Washed Sand B' then 'Line B'
  	   when Meshtype = 'Washed Sand C' then 'Line C'
  	   end as meshtype
  from sum_cte
  group by floor(sum_over_tph/20), meshtype,DATEPART (d, datetime), 
  DATEPART (m, datetime) 
  order by 1;

  I'm finding this issue on the 11/09  date

  example if  I use a wider date range

  set @start = '2021-11-07 00:00:00.000'

  set @end = '2021-11-11 23:59:00.000'

  I get the correct expected records retuned for the 9th

  

  if I use a date range

  set @start = '2021-11-08 00:00:00.000'

  set @end = '2021-11-11 23:59:00.000'

  or

  and [datetime] >= '2021-11-09 00:00:00.000'

  I get this weird extra record.....

  

  I tried different variations of the date to figure this out and not sure where this is coming from.

  any thought would be a great help.

  thank you.

   

• Steve Collins

  SSCommitted

  Points: 1686

  More actions

  November 11, 2021 at 1:24 pm

  #3952006

  Hi there.  Using BETWEEN and DATETIME is really not recommended.  Jeff pointed this out and I listened but didn't change the code.  Suspicious things 1) the datetime range doesn't seem complete, 2) the row_count splits between 66 and (63 + 3) which suggests the GROUP BY is not dividing distinctly, and 3) the 'time_grp' is negative.  Also, it's always a good practice to specify the length of VARCHAR declarations.  The variable isn't referenced anywhere but still... the default length is 1 which is almost always inappropriate and doesn't seem as intended here.

  Instead of

  declare @start datetime
  declare @end datetime
  declare @type varchar
  set @start = '2021-11-07 00:00:00.000'
  set @end = '2021-11-11 23:59:00.000'
  set @type = 'Raw Sand A'

  this

  declare @start datetime='2021-11-07 00:00:00.000',
          @end datetime='2021-11-11 23:59:59.999',
          @type varhcar(30)= 'Raw Sand A'
  

  and instead of

  and  [datetime] between @start and @end

  this

   and  [datetime] >= @start
   and  [datetime] <= @end
  

  Sample data with example would be helpful.  🙂

  Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  November 12, 2021 at 9:37 pm

  #3952528

  Steve,

  Thanks . I did try both recommendations on the varchar (30) and removed the datet range "between" and used this,

   and  [datetime] >= @start
   and  [datetime] <= @end

  However that additional record still appears.  what I  did find as a temporary work around was when I expanded the dat range an additional day the record  didn't appear.  as an example the date range from  8th- 11th  record appears , if I expand 7th-11th it works.

  I have attached a sample of the data results from the query , took me some time to find an easy way to get the records into text.

  (I created a temp table and did an insert into then generated a script from it)

  anyway hope fully with the data you can see what I'm running into

  thanks !

   

   

   

  • This reply was modified 2 years, 10 months ago by  gjoelson 29755.
  • This reply was modified 2 years, 10 months ago by  gjoelson 29755.

  Attachments:

  You must be logged in to view attached files.

• Jeff Moden

  SSC Guru

  Points: 1000539

  More actions

  November 13, 2021 at 7:27 pm

  #3952755

  gjoelson 29755 wrote:

  Hi,

  I'm trying to query the amount of minutes a column value stays below a threshold and then group it together

  Im Selecting records with  Values <= 20 and then use DATEDIFF(MINUTE, [Datetime1]  to return the time difference in minutes when the first record met the <=20 threshold and then went above that threshold.  Im not sure if I should do a sub query for the time or how to go about this - thanks!

  SELECT [datetime] 
       ,[tonsperhour] 
      --,DATEDIFF(MINUTE, [datetime], [datetime]) AS [ Minutes]
  FROM [dbo].[tons_per_hour]
    where whsecd =211
    and type in (' A','B')
    and  [datetime] >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
   group by datetime, tonsperhour     
   having tonsperhour <= 20

  

  Looking  for this simple output.

  

  Can you attach some readily consumable data for this original problem?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  November 16, 2021 at 8:38 pm

  #3953762

  Hi Jeff,

  Thanks for your patience....Yes , I've attached a file with some sample records from the source table [dbo].[tons_per_hour] that the above script uses .

  The sample includes the records from the  11/09 the date where the additional record is appearing as per my above description.

  hope that's what you needed, and it makes sense

  thank you

   

  • This reply was modified 2 years, 10 months ago by  gjoelson 29755.

  Attachments:

  You must be logged in to view attached files.

• pietlinden

  SSC Guru

  Points: 63198

  More actions

  November 16, 2021 at 10:08 pm

  #3953791

  Generate CREATE TABLE and INSERT scripts using the data table in your zip file, and then copy and paste the scripts into the window. most folks on here won't go near something like that. waaaay too dangerous to open.

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  November 17, 2021 at 2:27 am

  #3953835

  Ok got it , I tried the .sql type and it didnt like it , so I zipped it . thanks.

   

  anyhow here it is....

  USE [SSSPlants]
  GO
  /****** Object:  Table [dbo].[mytable2]    Script Date: 11/16/2021 2:31:38 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  CREATE TABLE [dbo].[mytable2](
  	[Datetime] [datetime] NULL,
  	[whsecd] [nvarchar](255) NULL,
  	[plant] [nvarchar](255) NULL,
  	[meshtype] [nvarchar](255) NULL,
  	[tonsperhour] [nvarchar](255) NULL,
  	 [nvarchar](255) NULL
  )
  
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'129.3441921677', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'22.5403699604', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0199856023', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'62.9052043040', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'119.4312469718', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'128.4676187253', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'130.1880503515', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.4453699510', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.4085307546', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.5143351216', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.1104565780', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.4044092639', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.2137601988', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'111.3813605620', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'131.6443920080', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'82.6125776774', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'91.8991608190', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'98.7791429993', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'98.9285553826', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'99.1218286460', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'99.9140922401', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'100.1965306312', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'100.7216685525', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'92.9148981145', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'102.3611215276', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'120.0829523777', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'119.6334945058', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'116.7565605961', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'119.0049942708', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'124.5001934260', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'129.6703555138', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'125.9759908018', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'127.1432163690', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'125.8426711735', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'124.9508646457', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'124.4925279254', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'123.9965490477', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'16.4825772488', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0224280416', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'1.5087031698', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'122.9945891852', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'106.5235112265', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'124.5082472229', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.6424373973', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.6507368790', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.5691794930', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.7609843422', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'143.1632262836', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'142.6707318981', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'112.3725218127', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0005464105', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0552114487', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.1954827660', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'30.9353401438', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'102.9453926059', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.6255140666', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'129.6991964563', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'129.6008696230', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.4358904952', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'138.5151535942', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.1908267829', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'138.9677451767', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'133.5130569029', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.9770782103', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.3516492461', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.2528831880', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.3208524786', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'132.5005944990', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.2790126795', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'133.8714125841', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.5116182034', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.6855856536', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.5685619794', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.4188717804', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.3812681714', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-05 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.3305273533', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2552234457', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2515404765', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2516686921', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2507922810', N'2')
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2519209655', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2502272249', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2500000596', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2500000596', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'8.0950576833', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'66.4561017089', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'110.2415623014', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'119.2710678130', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.9097855230', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'142.8156249497', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.7512948798', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.3078084865', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.3462169072', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.8582871245', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.0258850727', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.5493023919', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.2665056233', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.8322611868', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.0132461351', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.6748900091', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'133.9140493895', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.8937450408', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.6527877155', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.1838751023', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.7396755333', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.9795898832', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'117.8960128641', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'117.4167153980', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'81.1187279041', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2749847434', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2756321843', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'66.3952175522', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'118.8472055735', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'130.8988294801', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'85.8529122801', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0118351524', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0082105293', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0186702849', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'7.9065946215', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'107.9332510694', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'127.3194634027', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'98.2976438220', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'114.2601510437', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'132.1539056137', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'121.1974306615', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'87.1888962837', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'103.1982139131', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'116.6390393149', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'130.7334573479', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.3561751551', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.5963980361', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'131.3306494567', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.3761025570', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.6073066007', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'131.3910958247', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'124.7013166313', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.2769440101', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'145.1884742063', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'142.6844936525', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.6634801678', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'145.9547768540', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'138.7185025225', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'130.9975966213', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'133.2872693095', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.3696429936', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.3013953363', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'125.6926898866', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'97.3062096915', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'122.8307649408', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'118.3022874874', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'110.5650159008', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'119.1114829075', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'120.4630641479', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'120.4721269291', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'76.2195605601', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'110.2919162115', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'149.7277701372', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.6535934015', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'132.2466837064', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'129.4444786532', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'130.2405534667', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'69.3853203270', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.6696591894', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'133.2824393650', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'132.6260168784', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.3719353285', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'138.6175707808', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.0200883136', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.1961907764', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.7674263495', N'2')
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.8775386072', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.2944176036', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.3630106316', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.3133968778', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.6015482820', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.6311320674', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.0126145128', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.3052326192', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.8527511071', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.9988273422', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.8752150853', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.1198881721', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.1082283014', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'131.1750250829', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'133.0606813796', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'132.6986035634', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'115.0622600241', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'5.5942740155', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'64.4021530284', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'96.3425471833', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'117.0840719519', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'118.7091822497', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'131.2816283937', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'122.9839274574', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'119.7850828585', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.0925905087', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.1200805862', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'129.7073022916', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'113.6728692735', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'136.8487259223', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.5395876040', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'1.8010783372', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'4.8317115427', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.9195094912', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2298164640', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'85.0648722851', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'114.2107623806', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'130.4218490864', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.1936156159', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.0010037625', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'142.7608212913', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'140.4923412863', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.4495111009', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'135.3088016922', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'144.4671823410', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'137.6461981082', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'123.5477511423', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'134.7481296854', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'149.1786811562', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'159.8318948404', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'156.7885659684', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'158.0952381243', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'149.2468003766', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'146.9968958259', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'146.4449586969', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.5243044290', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'138.4223679461', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'139.3243135634', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'144.1806321034', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'145.5255984507', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'145.7820472869', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'148.3293372353', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'156.2530280576', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'141.3789392676', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'103.5163078003', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'6.6328155207', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'70.8208852157', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'110.1045447731', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'131.6348075648', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'120.6538520162', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'123.8092891781', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'107.1345060404', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'112.3621863576', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'123.2868640758', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'122.8129487869', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'121.8391057803', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'107.1568662668', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2474009204', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2499999403', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2499999403', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-06 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.2499999403', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0247462321', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0162348570', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-07 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0584271439', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'10.4323427635', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.3630455246', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'74.3612118502', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'30.3906099390', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-09 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0245509845', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0117940596', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0179095609', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'-0.0168684715', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-10 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 00:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 00:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 00:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 00:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 01:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-08 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 01:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 01:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 01:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 02:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 02:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 02:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 02:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 03:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 03:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 03:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 03:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 04:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 04:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 04:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 04:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 05:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 05:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 05:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 05:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  GO
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')
  

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  November 21, 2021 at 2:58 pm

  #3955323

  Jeff,

  I added sample data above related to the duplicate record,  let me know if what I gave here is ok.

  - Thanks.

• Jeff Moden

  SSC Guru

  Points: 1000539

  More actions

  November 22, 2021 at 2:31 am

  #3955410

  gjoelson 29755 wrote:

  Jeff,

  I added sample data above related to the duplicate record,  let me know if what I gave here is ok.

  - Thanks.

  The table is missing the 6th column.  So is the number of columns in the column names of the inserts. That means the code doesn't actually work.  You should test the code you expect us to use before posting it.  Saves a whole lot of time that way.

  I'm also interesting in knowing how you can have a negative number of tons per hour.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions

• gjoelson 29755

  SSC Eights!

  Points: 828

  More actions

  November 30, 2021 at 5:03 pm

  #3958729

  Only 5 columns ....That was a typo on the insert script. pls ignore.

  

  The negative tons are created by a convey belt scale , not always acturate.

  thanks.

  Greg