| Author |
Topic |
|
Chrisj485
Starting Member
3 Posts |
 Posted - 2009-06-23 : 19:47:27
|
| Hello everyone, first post. I have a question having to do with whether or not one could pause an SQL query at a certain time everyday, and then resume gathering data at some given time in the near future.Example: At my job, we are paid for our productivity on an hourly basis. At anytime during the day, we can track our productivity on the database. Only problem is, the database records ALL the hours we are "logged in" to our equipment. It doesn't take into account for our breaks and lunch. So therefore, at the end of the day we never really know what our EXACT productivity is for the day, because the clock has just been running all day despite the periods of time we were not working. Is there some way the IT techs could program the query to pause at say, 12pm for lunch and then resume 30 minutes later? I don't really have much experience with databases, but if this were possible it would be greatly appreciated to all the people I work with. Thank you very much for any help. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-24 : 09:45:11
|
| when you say you "track the productivity" how does your company do it? Is there some application that queries the database to see if you are logged in and assumes you are working? How does "they" know you logged in? If they do, couldnt you logoff when you go for lunch and log back in later?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-24 : 09:47:27
|
And, what exactly is "productivity"?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-24 : 09:58:59
|
quote:
Originally posted by Peso
And, what exactly is "productivity"?
E 12°55'05.63"N 56°04'39.26"
 good question...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
Chrisj485
Starting Member
3 Posts |
Posted - 2009-06-25 : 16:50:04
|
| Well basically the computer keeps track of how many "lines" or products we pick per hour to fill a customers order. We use a headset and control module that tells us where to go in the warehouse and what exactly to pick. Once we log on to our headset in the morning, the time starts recording. If we log off at lunch then log back on, the database takes into account for the down time, and still averages it all in. So essentially the computer will show that you worked 10 hours, when in reality you really only worked 8.5 hrs. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-06-26 : 12:11:48
|
| So how does the database know you logged out for the day, and not just for lunch?[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
Chrisj485
Starting Member
3 Posts |
Posted - 2009-06-27 : 15:06:24
|
| Once we log onto our equipment, the database begins recording time and doesn't stop until we log off for the day. We can still technically log off at anytime during the day, but as soon as we resume work, the database takes into account all that downtime that we weren't working and factors that into our productivity for the day. Hence, why it is so inaccurate. |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-06-29 : 09:54:12
|
quote:
Originally posted by Chrisj485
Once we log onto our equipment, the database begins recording time and doesn't stop until we log off for the day.
HOW does it know you have logged off for the day?[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQL or How to sell Used CarsFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-29 : 09:58:22
|
Maybe application just fetches MIN(workrecorddatetimecolumn) and MAX(workrecorddatetimecolumn) and gropu them by the day?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
SQL_DI
Starting Member
5 Posts |
Posted - 2009-06-29 : 13:54:58
|
| I at first thought, I would create a seperate set of tables. One is for user_ids that have looged in for the day, the next one is for all users and their scheduled break times. At the end of the day, run a job that removes the break times from your target table. Oh course it all depends on the result if this option would work. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-06-29 : 14:06:56
|
| You need to program for Auxillary time. A mode as part of your headset program that you can press that will track your "down" time separately. For example, if something comes in via your headset that you have to transfer or put on hold while you get an answer back.Jim |
|
|
|
|
Pausing SQL query (relating to my job)