I HAVE THIS TABLE AND I WANT TO APPLY PIVOT TABLES with sql 2005<br/>PLANNAME/CUTNAME/CUTID/AREA/MATSET/PERIOD/PLANE/CUBIN/MAT/TONS/VOL/GRADENAME/GRADEVALUE<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUC      0.103<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUM      0.196<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUR      0.088<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        TCU        0<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUC      0.53<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUM      0.25<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUR      0.12<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   TCU        0.67<br/><br/>I WOULD LIKE TO SHOW SOMETHING LIKE THIS<br/><br/>PLANNAME/CUTNAME/CUTID/AREA/MATSET/PERIOD/PLANE/CUBIN/MAT/TONS/VOL/RCUC/RCUM/RCUR/TCU<br/><br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2              0.103     0.196    0.088   0<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4         0.103     0.196    0.088   0.67<br/><br/><br/>thanks<br/>© 2009 Microsoft Corporation. All rights reserved.Thu, 18 Jun 2009 04:09:17 Z53198058-81dd-4e5b-982c-82aa4662ac4fhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/53198058-81dd-4e5b-982c-82aa4662ac4f#53198058-81dd-4e5b-982c-82aa4662ac4fhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/53198058-81dd-4e5b-982c-82aa4662ac4f#53198058-81dd-4e5b-982c-82aa4662ac4fedwg100http://social.msdn.microsoft.com/Profile/en-US/?user=edwg100I HAVE THIS TABLE AND I WANT TO APPLY PIVOT TABLES with sql 2005<br/>PLANNAME/CUTNAME/CUTID/AREA/MATSET/PERIOD/PLANE/CUBIN/MAT/TONS/VOL/GRADENAME/GRADEVALUE<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUC      0.103<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUM      0.196<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUR      0.088<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        TCU        0<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUC      0.53<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUM      0.25<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUR      0.12<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   TCU        0.67<br/><br/>I WOULD LIKE TO SHOW SOMETHING LIKE THIS<br/><br/>PLANNAME/CUTNAME/CUTID/AREA/MATSET/PERIOD/PLANE/CUBIN/MAT/TONS/VOL/RCUC/RCUM/RCUR/TCU<br/><br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2              0.103     0.196    0.088   0<br/>report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4         0.103     0.196    0.088   0.67<br/><br/><br/>thanks<br/>Wed, 17 Jun 2009 22:55:13 Z2009-06-17T22:55:13Zhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/53198058-81dd-4e5b-982c-82aa4662ac4f#7a94c2dc-64de-4163-bf46-fd0d75c32709http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/53198058-81dd-4e5b-982c-82aa4662ac4f#7a94c2dc-64de-4163-bf46-fd0d75c32709Rick Negrinhttp://social.msdn.microsoft.com/Profile/en-US/?user=Rick%20NegrinThis forum is for SQL Data Services, a Microsoft's Cloud database service offering. You will have a better chance of getting a fast answer in one of the SQL Server specific forums: <a href="http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&amp;SiteID=1"><span style="color:#0033cc">http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&amp;SiteID=1</span></a>  <br/><br/>Rick Negrin<br/>Lead Program Manager<br/>SQL Services<br/>MicrosoftThu, 18 Jun 2009 04:09:09 Z2009-06-18T04:09:09Z