For the record, I did find a way to do with another application..
mathematica makes it fairly trivial:
Say a query such as:
data = SQLSelect[someconnection,"sometable"]
Printing it:
TableForm[data]
Then simply:
Transpose[TableForm[data]]
On 09/30/2010 02:11 PM, Matthew Seaman wrote:
On 30/09/2010 12:31, Vincenzo Romano wrote:
2010/9/30 Ben Carbery:
Strange if this can't be done, I would have thought it a common request!
Just curiosity. Is there any other DB capable of such a thing?
MySQL does this using an alternate end-of
On 30/09/2010 12:31, Vincenzo Romano wrote:
> 2010/9/30 Ben Carbery :
>> Strange if this can't be done, I would have thought it a common request!
>
> Just curiosity. Is there any other DB capable of such a thing?
>
MySQL does this using an alternate end-of-statement character:
';' or '\g' gives
2010/9/30 Ben Carbery :
> On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano
> wrote:
>>
>> We also have the fantastic crosstab in tablefunc module (see chapter
>> F.36.1.4 for v9.0.0)
>>
> ..but these seem to be more pivot table functions that alter the data,
> rather than displaying it differently
On Thu, Sep 30, 2010 at 9:36 PM, Vincenzo Romano <
vincenzo.rom...@notorand.it> wrote:
> 2010/9/30 Raymond O'Donnell :
> > On 30/09/2010 12:17, Ben Carbery wrote:
> > Googling on "sql swap rows columns" found this:
> >
> >
> http://stackoverflow.com/questions/584232/t-sql-how-to-swap-rows-and-colu
2010/9/30 Raymond O'Donnell :
> On 30/09/2010 12:17, Ben Carbery wrote:
> Googling on "sql swap rows columns" found this:
>
> http://stackoverflow.com/questions/584232/t-sql-how-to-swap-rows-and-columns
>
> ...which you'll be able to adapt.
We also have the fantastic crosstab in tablefunc module (
On 30/09/2010 12:17, Ben Carbery wrote:
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output is
not 'wrapped'.
Is this possible? I have ha
2010/9/30 Ben Carbery :
> Strange if this can't be done, I would have thought it a common request!
Just curiosity. Is there any other DB capable of such a thing?
--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS
On Thu, Sep 30, 2010 at 9:19 PM, Tommy Gildseth
wrote:
> Ben Carbery wrote:
>
>> I have a query that returns many columns but few rows. I would like to
>> display output horizontally instead of vertically, i.e. rotating by 90
>> degress, so column headings appear in the left margin, and the output
On Thu, 2010-09-30 at 21:17 +1000, Ben Carbery wrote:
> I have a query that returns many columns but few rows. I would like to
> display output horizontally instead of vertically, i.e. rotating by 90
> degress, so column headings appear in the left margin, and the output
> is not
> 'wrapped'.
> Is
Ben Carbery wrote:
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output is
not 'wrapped'.
Is this possible? I have had no luck searching
I have a query that returns many columns but few rows. I would like to
display output horizontally instead of vertically, i.e. rotating by 90
degress, so column headings appear in the left margin, and the output is not
'wrapped'.
Is this possible? I have had no luck searching for this as rotate usu
12 matches
Mail list logo
