Popular Posts
JSRequest, Get parameters from querystring with javascript in SharePoint Provides method to parse query string, filename, and pathname from URL // Initialize first JSRequest.EnsureSetup(); // Get the current fil... ROBOCOPY: Robust File Copy for Windows -------------------------------------------------------------------------------    ROBOCOPY     ::     Robust File Copy for Windows --------... Convert pfx file to certificate file and private key file Use openssl
Stats
Get lastest record of workitem
SQL Server 
-- get lastest record of every instance

SELECT * FROM [HISTORY] H
WHERE [CREATEDTIME]  = 
    (
        SELECT MAX([CREATEDTIME]) FROM [HISTORY] M 
        WHERE M.[PROCESSINSTANCEID] = H.[PROCESSINSTANCEID] AND M.[EVENTTYPE] = H.[EVENTTYPE]
    )
ORDER BY [PROCESSINSTANCEID]