OK, how about you forget the code that i have written...i think it's causing more porblems than it's worth....
How would you do it?
There is no Key for the tables, here is a layout of the tables
DiscreteHistory
DateTime, Tagname, Value
21 Mar 2006 08:00:00...
Hi Simon,
1. Yep...my mistake it's supposed to call 'PenFridgeSumRun'...
2. The value in @Tagname (Gis_Pen_Container_Mycom_Run_Pen) is supposed to setup up AnalogueHistory, do i need a WHERE under the SELECT to specify the date range?
3. Yeah it's records every 5 seconds for both the power...
Hi,
I've got me treads mixed up....i'm trying to work out the amount of minutes that the compressor will be turned on ie. equal to 1 this the code i'm using now, but i'mnot sure that it's working...
SELECT @PenHow2On =
ISNULL((SELECT COUNT(*) FROM DiscreteHistory
WHERE datetime...
Experts!
I've been having a bit of a problem....
I have data on a compressor in two tables. One table contains the % load that the compressor is under as integer and the other table tells me when the compressor is turned on as a boolean.
I want to know what the average level of load is...
Experts!
I've been having a bit of a problem....
I have data on a compressor in two tables. One table contains the % load that the compressor is under as integer and the other table tells me when the compressor is turned on as a boolean.
I want to know what the average level of load is...
Hello Experts!
OK...have a access data base working lovely, but trying to get it to startup with a few parameters.
1. Different time - I've found a way of doing a fixed startup , this is using windows scheduler.
2. Different options - Whether the startup will email and print report, just email...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.