# Grouping , time difference in minutes

• Hi,

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

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

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

Looking  for this simple output.

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

`drop table if exists #foo;gocreate 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 */withsum_cte as (    select *, sum(tonsperhour) over (order by [datetime]) sum_over_tph    from #foo)select *,  sum_over_tph/20 calc_20_tphfrom sum_cteorder by 1;/* GROUP BY the FLOOR of the SUM OVER divided by 20 */withsum_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_ctegroup by floor(sum_over_tph/20)order by 1;`

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

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

-Thanks.

• This was removed by the editor as SPAM

• Steve,

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

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

`declare @start datetimedeclare @end datetimedeclare @type varcharset @start = '2021-11-07 00:00:00.000'set @end = '2021-11-11 23:59:00.000'set @type = 'Raw Sand A';withsum_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 meshtypefrom sum_ctegroup by floor(sum_over_tph/20), meshtype,DATEPART (d, datetime), DATEPART (m, datetime) order by 1;`

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

example if  I use a wider date range

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

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

I get the correct expected records retuned for the 9th

if I use a date range

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

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

or

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

I get this weird extra record.....

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

any thought would be a great help.

thank you.

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

`declare @start datetimedeclare @end datetimedeclare @type varcharset @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  [datetime] between @start and @end`

this

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

Sample data with example would be helpful.  🙂

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

• Steve,

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

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

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

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

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

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

thanks !

###### Attachments:
You must be logged in to view attached files.
• gjoelson 29755 wrote:

Hi,

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

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

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

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

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

• Hi Jeff,

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

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

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

thank you

###### Attachments:
You must be logged in to view attached files.
• Generate CREATE TABLE and INSERT scripts using the data table in your zip file, and then copy and paste the scripts into the window. most folks on here won't go near something like that. waaaay too dangerous to open.

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

anyhow here it is....

`USE [SSSPlants]GO/****** Object:  Table [dbo].[mytable2]    Script Date: 11/16/2021 2:31:38 PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE 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)GOINSERT [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')GOINSERT [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')GOINSERT [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')GOINSERT [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')GOINSERT [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')GOINSERT [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')GOINSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 06:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 07:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 08:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 09:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 10:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 11:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 12:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 13:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 14:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 15:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 16:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 17:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 18:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 19:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 20:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 21:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 22:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:00:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:15:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:30:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')INSERT [dbo].[mytable2] ([Datetime], [whsecd], [plant], [meshtype], [tonsperhour], ) VALUES (CAST(N'2021-11-11 23:45:00.000' AS DateTime), N'211', N'San Antonio Dry', N'Raw Sand B', N'0.0000000000', N'2')`
• Jeff,

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

- Thanks.

• gjoelson 29755 wrote:

Jeff,

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

- Thanks.

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

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

--Jeff Moden

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

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

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

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

thanks.

Greg

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