home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,561 of 19,505   
   Bob Barrows to All   
   Re: Break Up Large Table Query Into Resu   
   31 Jan 12 16:49:46   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca