Viewing 15 posts - 1 through 15 (of 67 total)
Only 5 columns ....That was a typo on the insert script. pls ignore.
The negative tons are created by a convey belt scale , not...
November 30, 2021 at 5:03 pm
Jeff,
I added sample data above related to the duplicate record, let me know if what I gave here is ok.
- Thanks.
November 21, 2021 at 2:58 pm
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: ...
November 17, 2021 at 2:27 am
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...
November 16, 2021 at 8:38 pm
Steve,
Thanks . I did try both recommendations on the varchar (30) and removed the datet range "between" and used this,
and [datetime] >= @start
and ...
November 12, 2021 at 9:37 pm
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...
November 10, 2021 at 7:35 pm
Steve, wow - thank you - That works ! would not have figured that one out, but learning all the time.
-Thanks.
October 20, 2021 at 2:10 pm
Got it .....
I ended up using the min/max totals and some grouping
thanks for the help.
September 9, 2021 at 4:35 pm
Thanks , I ran your query and it doesn't capture exactly what I need.....
So obviously there are multiple records per day for each product, in fact every 15 mins the...
September 8, 2021 at 9:53 pm
Agreed, I should have given data and the Table code please see below...
Thanks !
CREATE TABLE [dbo].[tons_produced](
[datetime] [datetime] NOT NULL,
[whsecd] [int] NOT NULL,
[plant] [varchar](20) NOT NULL,
[meshtype] [varchar](20) NOT...
September 8, 2021 at 5:12 pm
yes, that GetDateCDT is a function to get CST.
My question was really more about how to deal with the start and end totals. and how to to work CASE WHEN...
September 8, 2021 at 2:01 pm
OMG !!
Wow .....the cross apply worked like a Charm. and it was quick , even though now checking the table index is Clustered on identity, I will go ahead and...
July 2, 2021 at 9:10 pm
Scott, thanks.
Not sure that would work in our case, also not quite sure it it would address the ability to suppress certain reports and reset etc.
May 2, 2021 at 1:43 am
Brian,
Thank you for the ideas around the approach. we don't have Redgate unfortunately
I've followed your suggestion on the merge table with the bit "Alert sent" column. I think that will...
May 2, 2021 at 1:39 am
Thanks to everyone for their input , I'm going to go with the weekend steps first, and then circle back and revert to the above recommendations on the Public holiday...
March 13, 2021 at 4:42 pm
Viewing 15 posts - 1 through 15 (of 67 total)