Pivoting using LightSpeed

Hello!

Does anyone tryed pivoting using LightSpeed?

I tryed to do this using LINQ with help of people from stackoverflow community:

http://stackoverflow.com/questions/183585/sql-command-to-linq-pivoting

SQL I wanted to "translate" to LINQ looked like this (this is version for grouping by date - I have other views where i group by week and month):

SELECT
sum(case when Location="Location1" then Charge else 0 end) as Location1,
sum(case when Location="Location2" then Charge else 0 end) as Location2,
sum(case when Location="Location3" then Charge else 0 end) as Location3,
MAKEDATE(YEAR(OrderTime),DAYOFYEAR(OrderTime)) AS date FROM Sales
GROUP BY YEAR(OrderTime),MONTH(OrderTime)
ORDER BY OrderTime DESC 

and LINQ which was outputing the same values looks like this:

context.log_sales
.GroupBy(s => new {Year = OrderTime.Year, Month = OrderTime.Month})
.Select
( g => new {
  Date = new DateTime(g.Key.Year, g.Key.Month, 1),
  Location1 = g.Where(s => s.Location == "Location1").Sum(s => s.Charge),
  Location2 = g.Where(s => s.Location == "Location2").Sum(s => s.Charge),
  Location3 = g.Where(s => s.Location == "Location3").Sum(s => s.Charge),
  }
)
.OrderBy(x => x.Date); 

but SQL generated by LINQ was very huge (I can provide it if you want) so I decided to stick with using views. But how about using LightSpeed for pivoting? Can this be done without using views/stored procedures?

Thanks

No, you would need to use a view or stored procedure to do this using LightSpeed -- sorry!

No need to sorry. Just wanted to make sure if this can be done using LightSpeed.