Equivalent of Transform Pivot in Sybase

Plz if ne1 knows how to convert rows into columns ie to use Pivot tell me.I m using the DBArtisan tool for accessing the Sybase server.

Oct 9 '07 #1

Subscribe Post Reply

9526

RedSon

5,000

Expert 4TB

Plz if ne1 knows how to convert rows into columns ie to use Pivot tell me.I m using the DBArtisan tool for accessing the Sybase server.

Retrieved from the sybase website...

NewsGroup: sybase.public.sqlanywhere.product_futures_discussi on
Date: Mar 17,2006 01:53 pm
Created by: Glenn Paulley
Topic: Re: Pivot

Jason L wrote in news:4419d0d9.cb2.1681692777@sybase.com:

> It would be nice to have the pivot command that SQL server
> has.

Thanks for your interest in PIVOT (and UNPIVOT). We do not currently have
plans to implement these two operators at this point. However, we are well
aware that PIVOT and UNPIVOT can be very useful operations, particularly in
an OLAP context, and we will be evaluating these and other OLAP
improvements for a forthcoming release of SQL Anywhere.

Glenn

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Oct 9 '07 #2

Similar topics

Transpose data usign Transform-Pivot

by: carrionk | last post by:

Hi, I Have data stored with the following structure: Version Product Account Jan Feb Mar Apr May ... Dec 1 Brand1 403050 100 200 150 500 400 100 ...

Microsoft Access / VBA

VB to C sharp anyone can point out which is the equivalent

by: Hai Nguyen | last post by:

I'm learning C sharp and do not like vb much. I'm creatiing a wepage using panel to test myself. I tried to use these code below, which is written in VB, and to transform them to c sharp but I got...

C# / C Sharp

Equivalent to CREATE DEFAULT in Sybase

by: pankaj_wolfhunter | last post by:

Greetings, In sybase there is a create default statement in order to create a default object. like CREATE DEFAULT one as 1 go this object then can be bound to different table columns as...

DB2 Database

Equivalent of Sybase's @@transtate in DB2

by: pankaj_wolfhunter | last post by:

Greetings, In Sybase global variable @@transtate keeps track of the current state of a transaction. Sybase server determines what state to return by keeping track of any transaction changes...

DB2 Database

Data Transform from columns to rows

by: gapletona | last post by:

I have a table that I need to import into access. The table is monthly data where the month is the column header. I need to transform that data so that location code, month and number are the...

Microsoft Access / VBA

Pivot-Table Alternatives?

by: PeteCresswell | last post by:

I've got something called "Reference Rates". The idea is that on a given day, we have various rates of return for various entities. e.g. Libor 3-month return, Libor 6-month return, US Treasury...

Microsoft Access / VBA

Sql, Transform/pivot

by: nullgumby | last post by:

Working in Access 2003. I'm trying to write a query and have been looking at the TRANSFORM and PIVOT keywords, but can't seem to get them connected right. My table is like this:...

Microsoft Access / VBA

Transform Query Help required

by: KevinM | last post by:

Hi I have a database storing trip details. There's a parent table which stores the basic trip information and a child table that stores the countries to be visited information. The query I have at...

Microsoft Access / VBA

DB2 equivalent to this Sybase syntax

by: Richard | last post by:

I'm just getting my feet wet in DB2 UDB (9.x), after years as a Sybase DBA. In Sybase, if I wanted to delete data from one table based on joining that table to a second table, I'd use this syntax...

DB2 Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware