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

[Back to original message]