X Y query

Article View: borland.public.interbase.sql

Article #799

Back to borland.public.interbase.sql Previous Next

#799

From: adalberto baldini
Date: Wed, 09 May 2007 08:06

28 lines
1472 bytes

I have a procedure that joins two tables and  returns a pairs of columns 
like :

col_1   col_2
------  ------
  0        0
  0        1
  0        2
  1        1
  2        0
  2        1
.....

I would split col2 into n. columns to represent a matrix result :

a\b    0   1  2  3 ...
0      x   x  x
1          x
2      x   x
...

I don't know in advance num^ber of columns I could get.

could anyone suggest if exists any function that could do this or if I 
need to work with a visual component in Delphi ?

Thans
Adalberto BAldini

Technical Details

Message-ID: <46418103$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,3a941881090ec663,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Wed, 09 May 2007 10:06:21 +0200
From: adalberto baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: X Y query
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 85.1.66.67
Message-ID: <46418103$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178697987 85.1.66.67 (9 May 2007 01:06:27 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail