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 euro
february 2008: 650 euro
----
----
march 2009: 250 euro
april 2009: 400 euro
Now 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 Difference
400 300 100
Hope 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