Hey,
Thanks a lot! I didn't see this response until now.
I did not try it as I went with the column based solution. However
this looks like it will work.
I will implement and let you know.
Thanks again,
On 1/23/09, Peter Brawley wrote:
> Attila,
>
>>I would like to select only the most recen
Attila,
I would like to select only the most recent "targettime" within 1 minute and
only display only the rows that are "the latest" and print out all of the
stats as columns on a per toolname basis:
One way: a three-step:
1. There is a formula (see "Group data by time periods" at
http://ww
At 02:19 PM 1/22/2009, Weston, Craig (OFT) wrote:
From: Attila [mailto:attee...@gmail.com]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@lists.mysql.com
Subject: Need to pivot rows into columns
...
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc
From: Attila [mailto:attee...@gmail.com]
Sent: Thursday, January 22, 2009 3:06 PM
To: mysql@lists.mysql.com
Subject: Need to pivot rows into columns
...
I am using MySQL and have found some possibilities with SQL Server (Pivot,
crosstab, etc) ... but the requirements call for MySQL.
Is the above
Hi,
I have the following table:
CREATE TABLE DATA (
TARGET_TIME datetime NOT NULL,
SCENARIONAMEvarchar(20) NOT NULL,
TOOLNAME varchar(20) NOT NULL,
STATNAME varchar(100) NOT NULL,
STATVALUE int(10) NOT NULL,
PRIMARY KEY (TARGET_TIME, SCENARIONAME, SIMTOOLNAME, STATNAME)
);
I am t
sstab-1.17.
Hope this helps,
Jack
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 2:34 PM
To: [EMAIL PROTECTED]
Cc: MySql List
Subject: Re: How to turn rows into columns
What you are trying to create is called a "pivot table&q
com.ar> Fax to:
Subject: How to turn rows into columns
06/29/2004 04:35
Hi , Sorry to ask this question,
but I'm in desperate need to acomplish this report, and don't even know
it is possible to be done.
The thing is I have to turn rows from one table into columns
in other table. The first table looks like this
T1
---
id cod
---
1 bb
M ...
I did not run this vs a DB so please excuse syntax errors and if I
forgot some brackets. But in principle it should work fine.
Cheers
/rudy
-----Original Message-
From: Shazia Fazili [mailto:[EMAIL PROTECTED]
Sent: maandag 14 juli 2003 19:35
To: Rudy Metzger
Subject: RE: Rows into
BY invoiceid;
Cheers
/rudy
-Original Message-
From: Shazia Fazili [mailto:[EMAIL PROTECTED]
Sent: zaterdag 12 juli 2003 0:19
To: [EMAIL PROTECTED]
Subject: Rows into Columns
Hi,
I have a table PAYMENT which has 3 fields.. PaymentID,InvoiceID,Payment
PaymentID is th eprimary key
Hi,
I have a table PAYMENT which has 3 fields.. PaymentID,InvoiceID,Payment
PaymentID is th eprimary key. For each INvoiceID there can be more than one payment
but less than 6 payments.
PaymentIDInvoiceIDPayment
1123 23
2 123
11 matches
Mail list logo
