I need to select from a table and format the output like so (total is a SUM(value)):<BR><BR><pre class="ip-ubbcode-code-pre"> That's not what the SQL engine is for ...
Complex queries can be solved with a combination of simpler LINQ queries, anonymous objects and the Group/By/Into clauses. Using Group/By/Into will also give you the best possible performance for ...