Click here to Skip to main content
15,905,504 members
Home / Discussions / Database
   

Database

 
Questiona problem about stackoverflow Pin
nibabug12-Oct-07 3:27
nibabug12-Oct-07 3:27 
AnswerRe: a problem about stackoverflow Pin
Pete O'Hanlon12-Oct-07 4:44
mvePete O'Hanlon12-Oct-07 4:44 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:26
nibabug12-Oct-07 15:26 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:36
nibabug12-Oct-07 15:36 
QuestionChecking Duplicate values in Database Pin
codingrocks12-Oct-07 2:25
codingrocks12-Oct-07 2:25 
AnswerRe: Checking Duplicate values in Database Pin
Pete O'Hanlon12-Oct-07 2:31
mvePete O'Hanlon12-Oct-07 2:31 
AnswerRe: Checking Duplicate values in Database Pin
Skanless12-Oct-07 5:33
Skanless12-Oct-07 5:33 
QuestionHow to update a table using a Select statement in the Where Clause Pin
Skanless11-Oct-07 16:47
Skanless11-Oct-07 16:47 
I am trying to update a record in an Employee work hours table to record the employee time out. I need to find the last time the employee clocked in then assosciate the time out with the record. thus having a time in and timeout data.

UPDATE dbo.EmpWorkHours
SET Emp_Timeout = getdate()
where Emp_Timeout in (SELECT TOP 1 Emp_timeout
FROM dbo.EmpWorkHours
WHERE FK_Emp_Login_ID = 'MDoe74'
and Emp_Timeout IS NULL
ORDER BY RecordNum DESC
)

The script looks like it should be doing what I want it to do but it never finds any record, thought the record exist.

Any assistance will be great appreciated.

Skan

If you knew it would not compile why didn't you tell me?!?!?!

AnswerRe: How to update a table using a Select statement in the Where Clause [modified] Pin
joemonvarghese11-Oct-07 19:28
joemonvarghese11-Oct-07 19:28 
AnswerRe: How to update a table using a Select statement in the Where Clause Pin
Skanless12-Oct-07 21:08
Skanless12-Oct-07 21:08 
QuestionPlease Help to me this is very urgent issue Pin
mohd faiz11-Oct-07 12:52
mohd faiz11-Oct-07 12:52 
AnswerRe: Please Help to me this is very urgent issue Pin
Christian Graus11-Oct-07 13:41
protectorChristian Graus11-Oct-07 13:41 
AnswerRe: Please Help to me this is very urgent issue Pin
kubben12-Oct-07 2:13
kubben12-Oct-07 2:13 
AnswerRe: Please Help to me this is very urgent issue Pin
Skanless12-Oct-07 5:35
Skanless12-Oct-07 5:35 
Questionconnection string Pin
IamAmit11-Oct-07 5:49
IamAmit11-Oct-07 5:49 
AnswerRe: connection string Pin
Vasudevan Deepak Kumar11-Oct-07 7:24
Vasudevan Deepak Kumar11-Oct-07 7:24 
Question1:1 Relationships Pin
Brendan Vogt11-Oct-07 4:43
Brendan Vogt11-Oct-07 4:43 
AnswerRe: 1:1 Relationships Pin
John Gathogo11-Oct-07 4:47
John Gathogo11-Oct-07 4:47 
AnswerRe: 1:1 Relationships Pin
Rob Philpott11-Oct-07 4:54
Rob Philpott11-Oct-07 4:54 
GeneralRe: 1:1 Relationships Pin
Colin Angus Mackay11-Oct-07 5:22
Colin Angus Mackay11-Oct-07 5:22 
AnswerRe: 1:1 Relationships Pin
Skanless12-Oct-07 5:38
Skanless12-Oct-07 5:38 
GeneralRe: 1:1 Relationships Pin
Colin Angus Mackay12-Oct-07 9:03
Colin Angus Mackay12-Oct-07 9:03 
QuestionTable comparison in sql server 2000 Pin
Guru_yogi11-Oct-07 4:10
Guru_yogi11-Oct-07 4:10 
AnswerRe: Table comparison in sql server 2000 Pin
Rob Philpott11-Oct-07 4:37
Rob Philpott11-Oct-07 4:37 
AnswerRe: Table comparison in sql server 2000 Pin
John Gathogo11-Oct-07 4:44
John Gathogo11-Oct-07 4:44 

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.