CheckListItems CheckListItemId ItemName 1 name1 2 name2 3 name3 4 name4 5 name5 ... I can't seem to get the PIVOT syntax correct- it has to be dynamic as I don't know all the ItemNames (and there ...

SQL Server PIVOT (with calendar weeks) ElPresidente408 Jun 25, 2010 Jump to latest Follow Reply ...

This is the server-side version of PowerPivot and works in conjunction with SQL Server 2008 R2. PowerPivot workbooks can be published using Excel Services for dynamic access via Sharepoint.