[posted only]
On Oct 19, 2005, at 3:48 PM, sheeri kritzer wrote:
One particular bit of SQL you may find helpful is this:
concat(ifnull(a_id,""),ifnull(a_text,""))
concat with anything and a null value will produce a null value. That
snippet of sql code will help you get one answer from the 2
[posted only]
On Oct 19, 2005, at 4:07 PM, Jon Frisby wrote:
Create an Excel spreadsheet. Import the raw data, structured as-is,
into a worksheet. Select all the relevant columns. Go to Data ->
"Pivot Table and Pivot Chart Report". Click "Finish". From the
"PivotTable Field List", drag the
eled
"Drop Row Fields Here", then drag question ID into the box labeled "Drop
Column Fields Here".
Voila.
-JF
> -Original Message-
> From: Jeffrey Goldberg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 1:44 PM
> To: Brent Baisley
> C
TML
pivot table interface...)
-JF
> -Original Message-
> From: Jeffrey Goldberg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 19, 2005 12:24 PM
> To: mysql@lists.mysql.com
> Subject: Turning tables on their side
>
> I suspect that this is the wrong list for this
I agree with Brent.
One particular bit of SQL you may find helpful is this:
concat(ifnull(a_id,""),ifnull(a_text,""))
concat with anything and a null value will produce a null value. That
snippet of sql code will help you get one answer from the 2 the
original database had. Unless there's ever
[mailed and posted]
On Oct 19, 2005, at 3:34 PM, Brent Baisley wrote:
The person you inherited from formatted the data correctly in my
opinion.
I agree.
What you are trying to do is store the data as you see it, which is
rarely a normalized data model. Your presentation layer should
han
The person you inherited from formatted the data correctly in my
opinion. With the existing format, you can index all the data with a
minimum number of indexes and quickly compile results. It can scale
to any number of questions without having to modify the underlying
data structure. It can
I suspect that this is the wrong list for this kind of question, but
if someone could point me to appropriate sources, I would very much
appreciate it.
I am new to SQL but inherited project designed by someone who doesn't
seem answer his email anymore.
Essentially date were collected on t
