Update Group of Records?? 1

[byrne1]

The following SQL query returns three records. I want to update the timerecstatus field of the records that are returned by this query to 'C'. How can I modify this SQL query to do this in one step?

select projectcustid
from ((timerec
left join task on taskid=timerectaskid)
left join story on task.storyid=story.storyid)
left join project on project.projectid=story.projectid
where timerecstatus='n' and projectcustid='wgs'

 

[Niv3k]

update projectcustid set timerecstatus='c'
from ((timerec
left join task on taskid=timerectaskid)
left join story on task.storyid=story.storyid)
left join project on project.projectid=story.projectid
where timerecstatus='n' and projectcustid='wgs'

 

[MeanGreen]

Try this. If it works, change the rollback to commit:

Begin Transaction
--- check rows before update
select *
from ((timerec
left join task on taskid=timerectaskid)
left join story on task.storyid=story.storyid)
left join project on project.projectid=story.projectid
where timerecstatus='n' and projectcustid='wgs'

update timerec
set timerecstatus = 'C'
from ((timerec
left join task on taskid=timerectaskid)
left join story on task.storyid=story.storyid)
left join project on project.projectid=story.projectid
where timerecstatus='n' and projectcustid='wgs'

--- check rows after update

select *
from ((timerec
left join task on taskid=timerectaskid)
left join story on task.storyid=story.storyid)
left join project on project.projectid=story.projectid
where timerecstatus='n' and projectcustid='wgs'

Rollback Transaction

Hope this helps.

 

[byrne1]

Thanks guys. That worked!