Re: Transpose in SQL

From: jmorg <jmorg_at_concentric.net>
Date: 1998/10/29
Message-ID: <01be0317$93d518e0$ca9cadce@annmorga>#1/1

I have used CASE statements embedded in Sybase SQL for many on the fly recodes.
The CASE methods mentioned earlier or something similar should work with the newer versions of Sybase.
At least try them out before blindly following Hobarts 'Nice' RTFM suggestion.

Possibly Hobart needs to upgrade or read some books on advanced SQL himself ;-)

-- 

John

Hobart <Hobart_at_cincinatti.org> wrote in article
<3634CDB9.DEE6255B_at_cincinatti.org>...


> In Sybase, the CASE keyword is for scripting use. It can't be embedded in

 an


> SQL Statement.

> 

> You can transpose rows to columns and visa versa in a single Sybase SQL

> statement by using Sybase's characteristic functions and add'l functions.

 These


> include (SIGN, ABS, ISNULL, SUBSTRING, etc)

> 

> How you combine them depends on what you're trying to do. There are

 excellent


> books on the topic published by the SQL Forum Press.

> 

>

Received on Thu Oct 29 1998 - 00:00:00 CST