Grouping , time difference in minutes

Question

Post reply

Grouping , time difference in minutes

gjoelson 29755

SSC Eights!

Points: 848
More actions
October 19, 2021 at 4:16 pm

#3942059
Hi,
I'm trying to query the amount of minutes a column value stays below a threshold and then group it together
Im Selecting records with Values <= 20 and then use DATEDIFF(MINUTE, [Datetime1] to return the time difference in minutes when the first record met the <=20 threshold and then went above that threshold. Im not sure if I should do a sub query for the time or how to go about this - thanks!
```
SELECT [datetime] 
     ,[tonsperhour] 
    --,DATEDIFF(MINUTE, [datetime], [datetime]) AS [ Minutes]
FROM [dbo].[tons_per_hour]
  where whsecd =211
  and type in (' A','B')
  and  [datetime] >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
 group by datetime, tonsperhour     
 having tonsperhour <= 20
```
Looking for this simple output.

October 27, 2021 at 1:46 pm

This was removed by the editor as SPAM

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

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

Steve Collins SSCrazy Points: 2157 More actions · Answer 1

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

drop table if exists #foo;
go
create table #foo(
  [datetime]    datetime,
  tonsperhour   float);

Insert into #foo values
(getdate(), 10.2),
(dateadd(minute, 4, getdate()), 4.05),
(dateadd(minute, 5, getdate()), 4.3),
(dateadd(minute, 7, getdate()), 5.07),
(dateadd(minute, 14, getdate()), 5.111),
(dateadd(minute, 23, getdate()), 6.28),
(dateadd(minute, 32, getdate()), 2.76),
(dateadd(minute, 45, getdate()), 8.0385);

/* show the SUM OVER divided by 20 */
with
sum_cte as (
    select *, sum(tonsperhour) over (order by [datetime]) sum_over_tph
    from #foo)
select *,  sum_over_tph/20 calc_20_tph
from sum_cte
order by 1;

/* GROUP BY the FLOOR of the SUM OVER divided by 20 */
with
sum_cte as (
    select *, sum(tonsperhour) over (order by [datetime]) sum_over_tph
    from #foo)
select floor(sum_over_tph/20) time_grp, 
       min([datetime]) min_dt, max([datetime]) max_dt,
       count(*) row_count, sum(tonsperhour) sum_tph,
       datediff(minute, min([datetime]), max([datetime])) [Minutes Down]
from sum_cte
group by floor(sum_over_tph/20)
order by 1;

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

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 2

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

-Thanks.

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 3

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.

Steve Collins SSCrazy Points: 2157 More actions · Answer 4

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

Instead of

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

this

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

and instead of

and  [datetime] between @start and @end

this

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

Sample data with example would be helpful. 🙂

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

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 5

Steve,

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

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

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

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

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

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

thanks !

This reply was modified 3 years ago by gjoelson 29755.
This reply was modified 3 years ago by gjoelson 29755.

Attachments:

You must be logged in to view attached files.

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 6

gjoelson 29755 wrote:

Hi,
I'm trying to query the amount of minutes a column value stays below a threshold and then group it together
Im Selecting records with Values <= 20 and then use DATEDIFF(MINUTE, [Datetime1] to return the time difference in minutes when the first record met the <=20 threshold and then went above that threshold. Im not sure if I should do a sub query for the time or how to go about this - thanks!
SELECT [datetime] 
     ,[tonsperhour] 
    --,DATEDIFF(MINUTE, [datetime], [datetime]) AS [ Minutes]
FROM [dbo].[tons_per_hour]
  where whsecd =211
  and type in (' A','B')
  and  [datetime] >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)
 group by datetime, tonsperhour     
 having tonsperhour <= 20
Looking for this simple output.

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

--Jeff Moden

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

Change is inevitable... Change for the better is not.

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

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 7

Hi Jeff,

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

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

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

thank you

This reply was modified 3 years ago by gjoelson 29755.

Attachments:

You must be logged in to view attached files.

pietlinden SSC Guru Points: 63503 More actions · Answer 8

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

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 9

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

anyhow here it is....

USE [SSSPlants]
GO
/****** Object:  Table [dbo].[mytable2]    Script Date: 11/16/2021 2:31:38 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mytable2](
[Datetime] [datetime] NULL,
[whsecd] [nvarchar](255) NULL,
[plant] [nvarchar](255) NULL,
[meshtype] [nvarchar](255) NULL,
[tonsperhour] [nvarchar](255) NULL,
 [nvarchar](255) NULL
)

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

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 10

Jeff,

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

- Thanks.

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 11

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)

gjoelson 29755 SSC Eights! Points: 848 More actions · Answer 12

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