Crosstabular extension to isql look-alike. Feedback needed !!!
Posted in 1993
Topics: Server Administration
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 : a) 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 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 a product will be and is there any other similar product available ? All kind feedback is most welcome :=) Cheers, Shahid Ahmed