I am using sql 2008. I have a table with a field called 'prioritydate'
I need to update it with the value from the query below:
SELECT a.SDID ,
FROM BlueDotAdditionalDocs a
WHERE a.docsection = 'contact'
AND a.Docurrent = 1
AND CatalogId = 3
The query above will return one record per 'userid'
I need to take the 'expiration' and copy it to table 'users' where users.userid = a.userid from the above query.
set prioritydate = a.expiration
where users.userid = a.userid
but from the query above :) ... I hope that makes sense.
Not all records in the users table will have a value from the query, that is fine.