Grouping , time difference in minutes

  • 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

    thp

    Looking  for this simple output.

    thp2

     

  • 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

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

    -Thanks.

  • This was removed by the editor as SPAM

  • 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

    ex1

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

    ex2

    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.

     

  • 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

  • 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 !

     

     

     

    Attachments:
    You must be logged in to view attached files.
  • 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

    thp

    Looking  for this simple output.

    thp2

    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

  • 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

     

    Attachments:
    You must be logged in to view attached files.
  • 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.

  • 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')
  • Jeff,

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

    - Thanks.

  • 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

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

    scpt1

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

    thanks.

    Greg

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply