Back to the Data Model.
The Area being Modelled is :-
Tracking Machines and Counters
Subject: Problem to calculate difference between data in two rows inside one table
Question: What i need is to make database for tracking machine with two counters.
One counter represent "in" other "out".
Every machine have some location.
Once per month we are reading counters from that machines.
That reading we are comparing with last one and we are getting results.
For example: locationID=2 have machineID1, machineID2, machineID3 from
last month machines have some IN and OUT values.
that values from last month I need to compare with IN-OUT from this months.
© DataBase Answers Ltd. 2010