a list within a list and mutiple datanames

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

a list within a list and mutiple datanames

Author

Topic

jamie
Aged Yak Warrior

542 Posts

Posted - 2008-09-15 : 10:34:35

hi, I have 2 datasets and tables A and B, both group by Month.

How can I create a list with both tables grouping together ?

eg . so far I have

Jan
A
Feb
A

Jan
B
Feb
B

But what I need to do is :

Jan
A
B
Feb
A
B

When I try to add a list into another list using a different dataset it throws an error saying it cannot find field1 of table B..

any ideas ?

thank you.
jamie

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2008-09-15 : 10:50:12

select z.month, z.data from (
select month, data from a
union all
select month, data from b
) z
order by month, data

"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking

jamie
Aged Yak Warrior

542 Posts

Posted - 2008-09-15 : 11:05:34

hi,
problem is the queries show diferent data. so a union isn't an option..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-15 : 12:58:47

can you post queries used please?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources