By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,782 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

combining multiple crosstab queries into a query or temp table

P: n/a
I have 4 crosstabs which are keyed on a managerID field. I want to
combine them to provide the data for a graph. I currently have them
combined in a union query to produce 4 rows of data for each manager by
month. What i think i need is to change the orientation so i have a
column heading that represenst each crosstab, a manager ID column and
a month column.

So far ive thought of making a temp table using make table on one of
the queries and then do the same for each crosstab. Then combine all 4
into 1 query and use this as the source for my graph. This just seems
a bit tricky and im hoping someone could enlighten me as to a better
way of doing this

Many thanks

BeruthialsCat

May 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You should look at this book, Microsoft Data Analysis, by Michael
Alexander, very recently published. I have not read it all the way
through, but I know it talks about crosstab queries, which don't
transfer to SQL Server BTW.

ISBN: 978-0-7645-9978-1
www.wiley.com/go/accessdataanalysis

There are also things on the Internet about dynamic crosstab queries:

http://www.sqlmag.com/articles/index...ticleid=23162& (have to
register)
http://www.tek-tips.com/faqs.cfm?fid=5466
http://www.blueclaw-db.com/report_dy...stab_field.htm
http://support.microsoft.com/default...;en-us;Q328320

May 17 '06 #2

P: n/a
Thanks for the help. But i was too stupid to realise that i could do it
with the union query so its all good now i=and i have my graph which
changes on each change of manager

Ta tho

May 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.