I need to write a number of SQL reports based on a number of tables. Is there a standard technique on how to write reports?
I remember on technique where you define a tmp table with the appropriate columns for the report and then write several inserts and updates to populate rows into the tmp table. Then just a simple select out of the tmp table.
Yes, I guess it's possible. However, I need to "reposition" data on different rows of the report and guess its not so easy using a single select.
Just wondering if they are any standard receipies or patterns?