Crosstabular extension to isql look-alike. Feedback needed !!!
From: Media Central <mcentral_at_netcom.com>
Date: Thu, 19 Aug 1993 23:38:31 GMT
Message-ID: <mcentralCC15o8.BKK_at_netcom.com>
Date: Thu, 19 Aug 1993 23:38:31 GMT
Message-ID: <mcentralCC15o8.BKK_at_netcom.com>
Hi netters,
CrosstabSql is an interactive query tool similar to sybase isql. What
makes it different is the cross-tabulating extension which facilitates printing
of data across columns.
It supports the following features currently :
- Cross tabulate the ouput across multiple keys. For eg : 1> select Region, Quarter, Product_cd, amount from SALES 2> CROSSTAB sum($4) ACROSS $2 BY $3
- go
The output is as follows :
Q1 Q2 Q3 Q4
P1 1234 2343 2344 4353
P2 0 67779 0 8789
.
.
.
Pn 1234 234 234 324
The CROSSTAB syntax is : CROSSTAB aggregate_function($c)[,...] ACROSS $m,[...] BY $n,[...] b) Supports multiple edit buffers using History mechanism. I would like to know your opinion as to how useful this kind of aproduct will be and is there any other similar product available ?
All kind feedback is most welcome :=)
Cheers,
Shahid Ahmed
Received on Fri Aug 20 1993 - 01:38:31 CEST