June 6, 2007 at 2:27 pm
I am trying to update a column named endtime with current date based on a specific value in another column using following statement:
update
metadata.dbo.tabledetail
set
endtime = (Select getdate()
where
metadata.dbo.tabledetail = 'pdsadmin.person'
)
go
but getting an error:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "metadata.dbo.tabledetail" could not be bound.
How can I accomplish this task?
June 6, 2007 at 4:26 pm
Hi,
If I understand you correctly then you have to put a join into your update statement something like this...
UPDATE tablename1 SET EndTime = getdate()
FROM tablename1 a
JOIN tablename2 b
ON a.columnname = b.columnname
WHERE b.columnname = 'FilterText'
It might be a good idea to go through the UPDATE clause in books online as I've written that syntax from memory. Check out msdn for full documentation if you don't have a local copy.
Kindest Regards,
Frank Bazan
June 6, 2007 at 6:22 pm
I guess you are trying to do this:
update metadata.dbo.tabledetail set endtime = getdate()
where
metadata.dbo.tabledetail.PutYourFieldNameHere = 'pdsadmin.person'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply