MS SQL

MS SQL RSS

creating pivot table

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2008

Posts: 1

Reputation: pritha is an unknown quantity at this point

Solved Threads: 0

pritha

Offline

Newbie Poster

creating pivot table

Jul 31st, 2008

Hello,

Before posing question I have googled on pivot query,pivot sql query but none of the sites explained the syntax abut making a new table from a pivot query .And that's the reason I asked the question .I know the pivot query but how make a table of the results from the query.
Using INTO for the pivot query didn't work.

The following query works but I want to make a table

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
TRANSFORM sum(cCapacity) AS SumOfCapacity
SELECT jobworker, sum(cCapacity) AS Total
FROM cCapacity
GROUP BY JObWorker
PIVOT contract ;
TRANSFORM sum(cCapacity) AS SumOfCapacity
SELECT jobworker, sum(cCapacity) AS Total
FROM cCapacity
GROUP BY JObWorker
PIVOT contract ;

Thanks .

Pritha

Last edited by peter_budo; Aug 1st, 2008 at 12:30 pm. Reason: Keep It Organized - please use [code] tags

•

Join Date: Aug 2007

Posts: 160

Reputation: kb.net is an unknown quantity at this point

Solved Threads: 26

kb.net

Offline

Junior Poster

Re: creating pivot table

Aug 15th, 2008

Hi,

What are you using Access, MSSQL 2000 or MSSQL 2005

It is never about the number of languages you know, you either have the logic of programming or you don't ...

Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.