[RBG7-L] - RE: Table Creation using a tally command

[Walker, Buddy]

Steve   What I would do is create a temporary view and then project the view to a temporary table.     R:>CREATE TEMPORARY VIEW MyTestView (HowMany,VendorN) SELECT Count(*),VendorN FROM master GROUP BY VendorN     R:>PROJ TEMPORARY MyTestTable FROM MyTestView USI ALL   Buddy From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Monday, August 15, 2005 12:51 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Table Creation using a tally command I am trying to us a tally command to create a table on the fly IE: Tally VendorN from master Can any one advise me of the best way to accomplish this?   Thanks     Stephen Breen