Re: Crosstabular extension to isql look-alike. Feedback needed !!!

->From: mcentral@netcom.com (Media Central) ->Subject: Crosstabular extension to isql look-alike. Feedback needed !!! ->Date: Thu, 19 Aug 1993 23:38:31 GMT ->Reply-To: mcentral@netcom.com (Media Central) ->Organization: NETCOM On-line Communication Services (408 241-9760 guest) -> ->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 While I don't have an immediate need for it, I can certainly see that such a tool would be useful. The only tool I know of that already has this type of feature is Intelligent Query from IQ Software in Norcross, GA (800) 458-0386 Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\