20a91652   
   From: reb01501@NOyahooSPAM.com   
      
   pbd22 wrote:   
   > On Jan 31, 9:57 am, pbd22  wrote:   
   >> Hi.   
   >>   
   >> I am working in SQL Server 2005 and want to break up a table of 1M   
   >> rows into distinct results of 80,0000.   
   >>   
   >> I feel like this is basically   
   >>   
   >> use [database]   
   >>   
   >> select * from [table]   
   >> where email_address like '%gmail.com'   
   >> group by ????   
   >>   
   >> I am messing up with the group by (if this is the right way to go).   
   >> How do achieve this?   
   >>   
   >> Thanks.   
   >   
   > Anybody? To people use this group any more?   
      
   We sure do, but I, for one, don't understand your question. maybe show us:   
      
   CREATE TABLE statement   
   INSERT STATEMENT with sample data   
   desired results from supplied sample data   
      
   and we'll have a better chance of understanding your request (first off,   
   what's 80,0000 mean?)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)