|
|
Posted by Zero.NULL on 09/29/05 19:55
Hello David,
Yes I can use Reporting Tools, I can use third party tools as well but
I was more interested in getting some crosstab-style query and its pros
and cons, as Simon suggested some.
Well if the design I specified here is not appropriate, Let's have a
look on design you mentioned here:
CREATE TABLE accounts (trans_date DATETIME NOT NULL, trans_amount
NUMERIC(10,2), ....)
It will have data something like this:
2004-03-01 100
2004-04-01 500
2004-07-01 400
2004-08-01 600
2005-03-01 200
2005-04-01 500
2005-07-01 300
2005-08-01 400
2005-11-01 700
It will eazily serve me my output but what if I will have to show it in
my initial display (again crosstab-style query)?
Here Initial display means:
Year FirstQuarter SecondQuarter ThirdQuarter ForthQuarter
2004 - 100 500 1000 0
2005 - 200 500 700 700
Navigation:
[Reply to this message]
|