Click here to Skip to main content
15,881,588 members
Home / Discussions / Database
   

Database

 
AnswerRe: datediff problem Pin
Blue_Boy9-Sep-08 3:25
Blue_Boy9-Sep-08 3:25 
AnswerRe: datediff problem Pin
nelsonpaixao9-Sep-08 14:19
nelsonpaixao9-Sep-08 14:19 
QuestionSQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
DrukenProgrammer8-Sep-08 9:21
DrukenProgrammer8-Sep-08 9:21 
AnswerRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
Wendelius8-Sep-08 9:28
mentorWendelius8-Sep-08 9:28 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
DrukenProgrammer8-Sep-08 9:39
DrukenProgrammer8-Sep-08 9:39 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
Wendelius8-Sep-08 9:46
mentorWendelius8-Sep-08 9:46 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
DrukenProgrammer8-Sep-08 9:50
DrukenProgrammer8-Sep-08 9:50 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
Wendelius8-Sep-08 9:54
mentorWendelius8-Sep-08 9:54 
The code was for SQL Server which most of the people here use. It's been ages since I last used Access, but try just subtracting the two times (end.Date_TimeWorked - start.Date_TimeWorked). I'm not sure but it may give you the result you want.
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
DrukenProgrammer8-Sep-08 9:59
DrukenProgrammer8-Sep-08 9:59 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
Wendelius8-Sep-08 10:01
mentorWendelius8-Sep-08 10:01 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
DrukenProgrammer10-Sep-08 9:02
DrukenProgrammer10-Sep-08 9:02 
GeneralRe: SQL Query to find Timedifference between 2 items whose ID is same but different Status Pin
Wendelius10-Sep-08 9:52
mentorWendelius10-Sep-08 9:52 
QuestionHow could you detect if SQL database is opened and some actions performed? Pin
JUNEYT8-Sep-08 3:44
JUNEYT8-Sep-08 3:44 
AnswerMalicious access Pin
David Mujica8-Sep-08 3:54
David Mujica8-Sep-08 3:54 
GeneralRe: Malicious access Pin
JUNEYT8-Sep-08 4:27
JUNEYT8-Sep-08 4:27 
GeneralRe: Malicious access Pin
Ashfield8-Sep-08 9:38
Ashfield8-Sep-08 9:38 
QuestionHow can I let sql server 2000 backup my database on another computer automatically? Pin
Nada Adel7-Sep-08 22:12
Nada Adel7-Sep-08 22:12 
AnswerRe: How can I let sql server 2000 backup my database on another computer automatically? Pin
Mycroft Holmes8-Sep-08 0:17
professionalMycroft Holmes8-Sep-08 0:17 
AnswerRe: How can I let sql server 2000 backup my database on another computer automatically? Pin
Wendelius8-Sep-08 7:45
mentorWendelius8-Sep-08 7:45 
GeneralRe: How can I let sql server 2000 backup my database on another computer automatically? Pin
Mycroft Holmes8-Sep-08 14:39
professionalMycroft Holmes8-Sep-08 14:39 
Questiondelete repeated values Pin
Jassim Rahma7-Sep-08 10:32
Jassim Rahma7-Sep-08 10:32 
AnswerRe: delete repeated values Pin
Wendelius7-Sep-08 10:48
mentorWendelius7-Sep-08 10:48 
GeneralRe: delete repeated values Pin
Jassim Rahma7-Sep-08 11:08
Jassim Rahma7-Sep-08 11:08 
GeneralRe: delete repeated values Pin
Wendelius7-Sep-08 11:14
mentorWendelius7-Sep-08 11:14 
AnswerRe: delete repeated values Pin
Blue_Boy7-Sep-08 12:01
Blue_Boy7-Sep-08 12:01 

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.