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.
| Author |
Topic |
|
Coolda
Starting Member
10 Posts |
 Posted - 2012-05-21 : 11:54:04
|
| Hello,I am trying to create a SQL query for a stacked column chart that shows:The past 24 months readings for an equipment and having the bottom chart being the past 12 months from the current date and having the top part of chart to display the 24-13 month ago data information.Is there a query that will display the information seperately into two columns while having a similar Month information?Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:48:09
|
| you need to bring data grouped by dummy group and then repeated graph for this dummy group series------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SQL query for stacked column graph