Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    10

    Question Unanswered: Creating reports

    Hi
    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?

    e.g.
    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.

    Any other ideas?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    ...just write a single select statement?
    George
    Home | Blog

  3. #3
    Join Date
    Mar 2009
    Posts
    10
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •