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
TRANSFORM sum(cCapacity) AS SumOfCapacity
SELECT jobworker, sum(cCapacity) AS Total
FROM cCapacity
GROUP BY JObWorker
PIVOT contract ;Thanks .
Pritha
