A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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)
|MS SQL: Return all results in a single row separated by commas||1||27|
|VB.net Duplicating a table - primary key not created||3||32|
|SQL Server sunbquery nested in a CASE statement in a SELECT statement||5||17|
|changing page verifacation||1||28|