Today, I found two really good video presentations from Microsoft’s Tech Ed about Excel’s PowerPivot:
Building Sophisticated BI Applications Using Microsoft PowerPivot for Microsoft Excel
Will PowerPivot be the next big thing? I think so.
Drag&Drop, Slice&Dice, what else do you want? 🙂
Well, while I’m typing these posts…I’m usually listening to one of my favorite podcasts.
Made an easy clickable-iTunes-instant-download-list of the Club, House & Trance podcasts I’m listening to:
Release Yourself – Hosted by Roger Sanchez
Radio 538: Dance Department – Hosted by Dennis Ruyer
Push the Night – Mixed by Brad Miller
Beach House podcast – Mixed by Royce Cocciardi
Bar Grooves podcast
Funky Deep Tech House London – Mixed by Tinker
We Love Ibiza – Hosted by Tom Brown
I’ll be updating this list once I’ve found other great podcasts.
Got a podcast recommendation? Leave a comment!
I stumbled upon a great stored procedure for Recursive Queries (here), but I wanted to recreate it for AdventureWorks.
Note: This one only works on the previous AdventureWorks database (not 2008R2, the Employee table has changed). Soon I’ll be posting a modified version of this based upon the AdventureWorks2008R2 database.
Basicly the Employee-table is self referencing table with levels (also known as ‘Tree Walking‘) has an EmployeeId and ManagerId I’m going to use.
The code:
How to execute:
And ofcourse, the results are shown here:
A really nice thing about this SP is that it uses a parameter Root, which can be used to ‘climb’ the tree. For example, if I set @Root to be 12:
Want the SQL sourcecode? Click here
Clint Huijbers' Blog 