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

[Dawn Oakes]

Steve, You can do a couple of things:   Create a table and insert the rows into it.   Create table VendorTally (VendorN INT, VendorCount INT) INSERT into VendorTally select VendorN, (Count(*)) fro master group by VendorN   OR   Create a view.   Create view VwVendorTally as select VendorN, (Count(*)) fro master group by VendorN   Dawn From: Steve Breen [mailto:[EMAIL PROTECTED] 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