Popular Posts
SwiXml - TabbedPane TabbedPane.xml <?xml version="1.0" encoding="UTF-8"?> <panel layout="BorderLayout">     <label... jQuery Validation Engine default options ASP.NET MVC 5 Attribute Routing Enable attribute route Global.asax public class MvcApplication : System.Web.HttpApplication {     protected void Application_Start()     {...
Blog Archive
Stats
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 RelatedTable
ON
    Table1.Level1ID = RelatedTable.Level1ID
WHERE
    SomeColumn = Something
count sum:
SELECT * FROM Table1
LEFT JOIN
    (SELECT Level1ID, SUM(Bonus) AS TotalBonus FROM Table2 GROUP BY Level1ID) AS RelatedTable
ON
    Table1.Level1ID = RelatedTable.Level1ID
WHERE
    SomeColumn = Something