Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

I need help Please :( Expand / Collapse
Author
Message
Posted Saturday, October 05, 2013 5:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 35,979, Visits: 30,270
It's going to be very interesting if the company ever adds extra readers.

We're talking about computers here and it always fascinates me that an IN/OUT reader system doesn't do a simple bit of checking. For example, an OUT punch should be rejected if there is no open IN punch. An IN punch should not be allowed if there are any other IN punches that are still open. Trying to reconcile double punches and missed punches is solving the wrong bloody problem. Someone needs to fix the read system so that it works correctly.

If such a reader system is used to determine payroll, then trying to fix after-the-fact extra and missed punches is actually messing with people's pay. It's the reader system that needs to be fixed... not the reporting. The reporting is nothing more than a symptom of a bigger 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." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1501876
Posted Monday, October 07, 2013 1:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:33 AM
Points: 6,754, Visits: 12,854
Jeff Moden (10/5/2013)
It's going to be very interesting if the company ever adds extra readers.

We're talking about computers here and it always fascinates me that an IN/OUT reader system doesn't do a simple bit of checking. For example, an OUT punch should be rejected if there is no open IN punch. An IN punch should not be allowed if there are any other IN punches that are still open. Trying to reconcile double punches and missed punches is solving the wrong bloody problem. Someone needs to fix the read system so that it works correctly.

If such a reader system is used to determine payroll, then trying to fix after-the-fact extra and missed punches is actually messing with people's pay. It's the reader system that needs to be fixed... not the reporting. The reporting is nothing more than a symptom of a bigger problem.


+1, good points Jeff.
But it is what it is, and Sharon has to deal with it.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1502005
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse