Nice code, Both works well in my hands

redtux1 (6/2/2015)

---

The article should have emphasized the "small" . When the the data sets get either large or the query is complex you do really need a temp table.

And to...

Thanks a lot for sharing.

You mentioned that "PowerPivot uses the same engine that MS Analysis Services (SSAS) Tabular uses and PowerPivot data sits inside that engine". However, my computer...

without order by, How can You select the top N?

ME me. I have noticed that before submitting the answer