Update Statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Update Statement

Author

Topic

melcraig
Starting Member

39 Posts

Posted - 2006-05-16 : 14:49:47

I want to Update the following:

Update t_ParticipantStatus
SET t_ParticipantStatus.DateCompleted = tiaParticipants.DateCompletedTng

SELECT dbo.t_ParticipantStatus.EmployeeID, dbo.t_ParticipantStatus.DateCompleted, dbo.t_ParticipantStatus.ModuleID,
dbo.tiaParticipants.DateCompletedTng
FROM dbo.tiaParticipants LEFT OUTER JOIN
dbo.t_ParticipantStatus ON dbo.tiaParticipants.EmployeeID = dbo.t_ParticipantStatus.EmployeeID
WHERE (dbo.t_ParticipantStatus.ModuleID = '1') AND (dbo.tiaParticipants.DateCompletedTng > CONVERT(DATETIME, '2005-11-02 00:00:00', 102))

I can't get it to Update correctly!
Thanks for your help,
Mel

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-05-16 : 15:08:45

Try the following:


Update t_ParticipantStatus
SET t_ParticipantStatus.DateCompleted = tiaParticipants.DateCompletedTng
SELECT     dbo.t_ParticipantStatus.EmployeeID, dbo.t_ParticipantStatus.DateCompleted, dbo.t_ParticipantStatus.ModuleID, dbo.tiaParticipants.DateCompletedTng
FROM dbo.tiaParticipants 
LEFT OUTER JOIN dbo.t_ParticipantStatus 
     ON dbo.tiaParticipants.EmployeeID = dbo.t_ParticipantStatus.EmployeeID
WHERE (dbo.t_ParticipantStatus.ModuleID = '1') AND (dbo.tiaParticipants.DateCompletedTng > CONVERT(DATETIME, '2005-11-02 00:00:00', 102))

Srinika

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources