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

Mon, 15 Aug 2005 10:06:43 -0700

 
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Dawn Oakes
Sent: Monday, August 15, 2005 1:01 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Table Creation using a tally command

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

 

 

Reply via email to