Re: [SQL] record fields as columns in reports

2007-06-28 Thread A. Kretschmer
am Thu, dem 28.06.2007, um 16:46:15 +0200 mailte Reinoud van Leeuwen folgendes: > Hi everybody, > > I have a script that runs every night and produces a list of a few error > conditions and the number. > > My manager would like it in a form where he can produce some charts in a > spreadsheet (

Re: [SQL] record fields as columns in reports

2007-06-28 Thread Rodrigo De León
On 6/28/07, Reinoud van Leeuwen <[EMAIL PROTECTED]> wrote: So the table I store the errormessages in has a format like this: CREATE TABLE repport_history ( rundate date, errordescription character varying(255), number bigint ) And I would like an output with something like: 06

Re: [SQL] record fields as columns in reports

2007-06-28 Thread Andrew Sullivan
On Thu, Jun 28, 2007 at 04:46:15PM +0200, Reinoud van Leeuwen wrote: > And I would like an output with something like: > > 06/22 06/2306/2406/25 > ERROR1 10 10 9 8 > ERROR2250300 220 200 > ERROR3 4 2 0

[SQL] record fields as columns in reports

2007-06-28 Thread Reinoud van Leeuwen
Hi everybody, I have a script that runs every night and produces a list of a few error conditions and the number. My manager would like it in a form where he can produce some charts in a spreadsheet (that's probably why he's a manager ";-). So the table I store the errormessages in has a forma