PIVOT TABLE WITH SQL

Question

I HAVE THIS TABLE AND I WANT TO APPLY PIVOT TABLES with sql 2005
PLANNAME/CUTNAME/CUTID/AREA/MATSET/PERIOD/PLANE/CUBIN/MAT/TONS/VOL/GRADENAME/GRADEVALUE
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUC      0.103
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUM      0.196
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        RCUR      0.088
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2        TCU        0
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUC      0.53
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUM      0.25
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   RCUR      0.12
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4   TCU        0.67

I WOULD LIKE TO SHOW SOMETHING LIKE THIS

PLANNAME/CUTNAME/CUTID/AREA/MATSET/PERIOD/PLANE/CUBIN/MAT/TONS/VOL/RCUC/RCUM/RCUR/TCU

report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      DEFAULT      9.216           115.2              0.103     0.196    0.088   0
report    AMT2_1   GUID37106044166102462132501655725663633065666175    report   REPORTM    Period     Level 4250      0      HYPOGENE    43640.832   545510.4         0.103     0.196    0.088   0.67


thanks

Answer 1

This 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: http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&SiteID=1  

Rick Negrin
Lead Program Manager
SQL Services
Microsoft