Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
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)
Join the community of 500,000 technology professionals and ask your questions.