Popular Posts
Remove file not in list Join related table and count rows or sum sql server 2005 count rows: SELECT * FROM Table1 LEFT JOIN     (SELECT Level1ID, COUNT(Level2ID) AS Total FROM Table2 GROUP BY Level1ID) AS... ADD ... THEN ... UNTIL ... data: begin of SERIES, N1 type I value 10, N2 type I value 20, N3 type I value 30, N4 type I value 40, ...
Stats
Convert relative url to absolute 
Uri baseUri = new Uri("http://www.domain.com/path/sample");
Uri absoluteUri = new Uri(baseUri, "../../other/path");
Uri uri;
Uri.TryCreate("http://www.domain.com/base/uri", "../relative/uri", out uri);