Groups > comp.databases.ms-sqlserver > #915

Re: Break Up Large Table Query Into Results of N Rows

From	pbd22 <dushkin@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Break Up Large Table Query Into Results of N Rows
Date	Tue, 31 Jan 2012 12:50:27 -0800 (PST)
Organization	http://groups.google.com
Lines	20
Message-ID	<5609f740-b8b5-4876-8a4a-5633aa91a3a8@eb6g2000vbb.googlegroups.com> (permalink)
References	<eb6a2653-8609-495a-b05f-16a104b22f05@y10g2000vbn.googlegroups.com>
NNTP-Posting-Host	12.148.169.2
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1328043027 8168 127.0.0.1 (31 Jan 2012 20:50:27 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Tue, 31 Jan 2012 20:50:27 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	eb6g2000vbb.googlegroups.com; posting-host=12.148.169.2; posting-account=hWthrQoAAABdiEHuw7JB4LQSSQ2Egqjv
User-Agent	G2/1.0
X-HTTP-Via	1.1 localhost.localdomain[0A020408]
X-Google-Web-Client	true
X-Google-Header-Order	HUALESRCV
X-HTTP-UserAgent	Mozilla/5.0 (Windows NT 6.0; WOW64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1,gzip(gfe)
Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.franciliens.net!feed.ac-versailles.fr!proxad.net!feeder1-2.proxad.net!74.125.64.80.MISMATCH!postnews.google.com!eb6g2000vbb.googlegroups.com!not-for-mail
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:915

Show key headers only | View raw

On Jan 31, 9:57 am, pbd22 <dush...@gmail.com> 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?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Break Up Large Table Query Into Results of N Rows pbd22 <dushkin@gmail.com> - 2012-01-31 06:57 -0800
  Re: Break Up Large Table Query Into Results of N Rows pbd22 <dushkin@gmail.com> - 2012-01-31 12:50 -0800
    Re: Break Up Large Table Query Into Results of N Rows "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-01-31 16:49 -0500
    Re: Break Up Large Table Query Into Results of N Rows Erland Sommarskog <esquel@sommarskog.se> - 2012-01-31 23:03 +0100
      Re: Break Up Large Table Query Into Results of N Rows pbd22 <dushkin@gmail.com> - 2012-02-01 07:34 -0800
        Re: Break Up Large Table Query Into Results of N Rows "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-02-01 15:36 -0500
        Re: Break Up Large Table Query Into Results of N Rows Erland Sommarskog <esquel@sommarskog.se> - 2012-02-01 23:54 +0100

csiph-web