Click here to Skip to main content
15,903,724 members
Home / Discussions / Database
   

Database

 
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 
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 
Thanks for your response. I figured it out, using the code below.

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

What was wrong with it you may ask? Well, I was selecting the Emp_timeout field which was null. I was then telling to update a record where getdate() equals the value in the Emp_Timeout field. That would never happen because at the time of the query Emp_timeout field is NULL thus it will never equal getdate().

Hope this helps.

Skan

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

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 
AnswerRe: Table comparison in sql server 2000 Pin
Hesham Amin12-Oct-07 8:41
Hesham Amin12-Oct-07 8:41 
Questionvarchar and nvarchar Pin
Brendan Vogt11-Oct-07 3:55
Brendan Vogt11-Oct-07 3:55 

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.