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 had no luck searching for this as rotate
> usually means log rotation.
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.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie