Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
I tried a merge but it tells me I cannot do an update in a WHEN NOT MATCHED MERGE into tblPermTask as pt USING (Select pt.intQId, strSSN from tblPermTaskTemp pt INNER JOIN tblSRPQuestion q on q.intquestionId = pt.intQId Where bitFilterOnly = 1) as t on t.intQId = pt.intQuestionId and pt.strssn = t.strSSN WHEN NOT MATCHED THEN UPDATE set dtCompleted = getdate(), strClosedBy = 'SYSTEM'; This is based on the old systems when bitFilterOnly did not exist but it does not work with the bitFilter only. It updates all teh records that do not have the bitFilterOnly which I do not want it too. update tblPermTask set dtCompleted = getdate(), strClosedBy = 'SYSTEM' where dtCompleted is null and convert(varchar(10), intQuestionId) + '|' + strSSN not in (select convert(varchar(10), intQId) + '|' + strSSN from tblPermTaskTemp pt INNER JOIN tblSRPQuestion q on q.intquestionId = pt.intQId Where bitFilterOnly = 1)
|SQL Query Assistance||4||31|
|Export data with an insert trigger to a linked server||20||21|
|Auditing in Azure SQL Database||3||28|
|Determine which columns have the exact value||1||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!