AnsweredAssumed Answered

SQL Update Table Help

Question asked by TomConnery on Dec 10, 2009
Latest reply on Oct 10, 2011 by b
Hey there Clarity Pros, I have a question  around SQL updates.   I'm attempting to do the following:  Based on a resource records termination date, mark their resource record as inactive on both the srm_resources side and the cmn_sec users side.  My select statement below identifies the users I need to inactivate, now I just need the right sql to perform the update or insert to set is_active to '0' on srm_resources for that specific resource and also set user_status_id = '202' on cmn_sec_users for that same resource.  Can this be done?   What do I need to do?   Many thanks!    SELECT GETDATE() DATE, r.USER_ID, c.USER_NAME, r.FIRST_NAME, r.LAST_NAME, r.DATE_OF_HIRE, r.DATE_OF_TERMINATION, r.IS_ACTIVE, c.USER_STATUS_ID
FROM niku.CMN_SEC_USERS C, niku.SRM_RESOURCES R
WHERE c.ID = r.USER_ID
AND r.DATE_OF_TERMINATION = CONVERT(nvarchar(30), (GETDATE()+1), 101)  

Outcomes