Click here to Skip to main content
16,021,687 members
Home / Discussions / Database
   

Database

 
AnswerRe: locking on select Pin
Hitesh R5-Nov-12 22:42
Hitesh R5-Nov-12 22:42 
QuestionWrong retrieved attendance and leave data Pin
Amr Muhammed19-Oct-12 16:04
Amr Muhammed19-Oct-12 16:04 
AnswerRe: Wrong retrieved attendance and leave data Pin
Mycroft Holmes20-Oct-12 2:10
professionalMycroft Holmes20-Oct-12 2:10 
GeneralRe: Wrong retrieved attendance and leave data Pin
Amr Muhammed21-Oct-12 12:20
Amr Muhammed21-Oct-12 12:20 
GeneralRe: Wrong retrieved attendance and leave data Pin
Mycroft Holmes21-Oct-12 13:01
professionalMycroft Holmes21-Oct-12 13:01 
AnswerAssumed off Pin
David Mujica22-Oct-12 5:37
David Mujica22-Oct-12 5:37 
AnswerRe: Wrong retrieved attendance and leave data Pin
Michael Potter22-Oct-12 8:04
Michael Potter22-Oct-12 8:04 
GeneralRe: Wrong retrieved attendance and leave data Pin
Amr Muhammed22-Oct-12 15:19
Amr Muhammed22-Oct-12 15:19 
The fingerprint device is working that way. It is manufactured with that switch button. So if the employee of a given shift was about leaving while the security guys did not change the in/out state of the fingerprint device and that employee put his finger he will have 2 records each with in state and when reading the data this employee considered did not record leaving state. On the other hand, if the employee of a second shift came before his shift start time and the security guys did not switch the device from out state "as they changed the in state to out state at the end of the first shift" and that employee puts his finger so the final result that this employee has 2 records with a leave state. Such matter of wrong records is a case sensitive as the company will depend on the data in calculating the overtime and in salary discount(s). I hope my idea is clear now. The shift 1 and shift 2 begins and ends on 08:00:00 AM - 04:00:00 PM and 06:30:00 PM - 08:00:00 AM on the next day.
QuestionReport of the SQL Server Agent, job scheduler Pin
vanikanc19-Oct-12 8:05
vanikanc19-Oct-12 8:05 
AnswerRe: Report of the SQL Server Agent, job scheduler Pin
fjdiewornncalwe19-Oct-12 9:07
professionalfjdiewornncalwe19-Oct-12 9:07 
QuestionCopy a tables to another database (Flashdisk) Pin
Richard.Berry10018-Oct-12 11:50
Richard.Berry10018-Oct-12 11:50 
AnswerRe: Copy a tables to another database (Flashdisk) Pin
R. Giskard Reventlov18-Oct-12 12:22
R. Giskard Reventlov18-Oct-12 12:22 
GeneralRe: Copy a tables to another database (Flashdisk) Pin
Richard.Berry10018-Oct-12 12:40
Richard.Berry10018-Oct-12 12:40 
GeneralRe: Copy a tables to another database (Flashdisk) Pin
R. Giskard Reventlov18-Oct-12 13:14
R. Giskard Reventlov18-Oct-12 13:14 
GeneralRe: Copy a tables to another database (Flashdisk) Pin
Richard.Berry10018-Oct-12 14:10
Richard.Berry10018-Oct-12 14:10 
AnswerCreate small db, then use backup PinPopular
David Mujica19-Oct-12 6:21
David Mujica19-Oct-12 6:21 
GeneralRe: Create small db, then use backup Pin
fjdiewornncalwe19-Oct-12 6:43
professionalfjdiewornncalwe19-Oct-12 6:43 
GeneralRe: Create small db, then use backup Pin
Richard.Berry10025-Oct-12 5:55
Richard.Berry10025-Oct-12 5:55 
Question10g to 11g migration. Pin
vanikanc17-Oct-12 7:44
vanikanc17-Oct-12 7:44 
AnswerRe: 10g to 11g migration. Pin
Eddy Vluggen17-Oct-12 9:31
professionalEddy Vluggen17-Oct-12 9:31 
QuestionHow to access window ? Pin
nghia09t317-Oct-12 5:27
nghia09t317-Oct-12 5:27 
AnswerRe: How to access window ? Pin
Eddy Vluggen17-Oct-12 9:32
professionalEddy Vluggen17-Oct-12 9:32 
GeneralRe: How to access window ? Pin
nghia09t317-Oct-12 12:47
nghia09t317-Oct-12 12:47 
AnswerRe: How to access window ? Pin
Richard Andrew x6417-Oct-12 14:06
professionalRichard Andrew x6417-Oct-12 14:06 
GeneralRe: How to access window ? Pin
nghia09t317-Oct-12 14:29
nghia09t317-Oct-12 14:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.