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 |
|
JNotenboom
Starting Member
27 Posts |
 Posted - 2009-04-17 : 03:38:10
|
| Good morning,I have a table which consist of revenues in a certain period. for example:january 2008: 400 eurofebruary 2008: 650 euro--------march 2009: 250 euroapril 2009: 400 euroNow I want to generate a result from a query (which eventually shows up in a report) which shows the comparison of 2 periods.For example, I want to compare the period feb/march 2008 with the period aug/sept/october 2008. Basically, I enter 4 parameters to it via input boxes: start date period 1, start date period 2, end date period 2 and end date period 2.The result shows something like:period 1 period 2 Difference400 300 100Hope this is clear for all of you;For a better explanation from my site I reduced the complexity of the actual problem ;)Thanx, Johan======'Our solution will be part of your problem' |
|
|
|
|
|
Comparing periods