We have meetings on the second Thursday of every month.  Our group meets at the Microsoft Heartland District Office in the Southfield Town Center.  The office is on the 19th floor of the 1000 Building, and there are signs directing you to the conference room where the meeting will be held.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - General Q&A session & Announcements
6:30 - 7:30 - Presentation(s)
7:30 - ?? - Door prizes and Question & Answer session

Topic:	Converting Rows to Columns:  Cross Tabs, Pivots, and "Nasty Fast" Reports
Date:	Thursday, January 14th, 2009
Speakers:	Jeff Moden, SQL Server MVP
Location:	Microsoft Heartland District Offices, 1000 Town Center, Southfield, MI
Overview:	Jeff revisits a comparatively "ancient" yet highly effective technique for solving the ages old problem of converting rows to columns.  He's also thrown in a couple of "black arts" methods for producing reports with multiple disparate aggregations on the same line, line sub-totals, grand totals, and a whole lot more.  Jeff will demo these nearly forgotten methods with his old friend, the million row test table, to produce a 1 year report by month for 8 companies that runs in seconds.  He'll end the night with the creation of a view that may leave you asking why you need a data mart at all.

I have set up an e-mail address for SEMSSUG related issues, so it doesn't  generate as much traffic to my work e-mail account.  Please send any questions, concerns, etc to Joseph.Fleming@sqlpass.org