Can I add data to a pivot cache?
 

I have created a pivot cache from external data (with some great help from
Hector Miguel) - what I would like to do now is rather than use UNION queries
I would prefer to keep building a pivot cache. If possible I don't know the
syntax and I don't know if it would be more efficient than UNION queries
(would necessitate between 6 and 70 UNION statements depending on data) - I
would just prefer to manage the pivot cache over building the query (although
have already written the code on the sql creation - just want to test against
building a pivot cache one data set at a time for speed)

Anybody know for sure on this one? Thanks and hth --