Ok, what do you do with let's say a max of 16 rows per group?

Here's a demo with the system tables, adjust to your own needs.

SELECT

T.name,

STUFF((

SELECT

...

Buy bigger server.

Seriously what end user would actually look at 53 M rows??????????????????????????

You need to redesign the process to return less data (or summerized).

Revenant (1/3/2012)

---

Henrico Bekker (1/3/2012)

---

How can I convince my manager, and company that its a great idea to send me to SQL 2012 Launch?

http://devconnections.com/shows/sp2012/default.aspx?s=185

flying to the USA from South Africa and...

MyDoggieJessie (1/3/2012)

---

GilaMonster (1/3/2012)

---

Err, that (headline article today) is the updated version. Unless you're volunteering to...

Just to say something else.

SELECT TOP (0) * INTO #tmp FROM dbo.table

:hehe:

PS

Any ressemblance with any member of this forum is pure coincidence! Unless fully intended!

:-P:hehe:

You mean this?

http://www.youtube.com/watch?v=RzHyeMaHm2s

Ok I'll say it. <points to self> RTFM :w00t:.

Thanks for the aknolegment of picking 1 small typo...

And if you guys are really awake you'll realize that even with only 2-3 regular female posters, guess who's on top of us all :hehe:.

Happy 2K12, t'was about time!

GilaMonster (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

GilaMonster (1/3/2012)

---

No, no, no, no, no!

And...

SQLRNNR (1/3/2012)

---

GilaMonster (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

GilaMonster (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

Turns out it was another mistake (big one, but not as big). He had left live vm snapshots on for 2 weeks. Managed...

So what's the real drive then?

GilaMonster (1/3/2012)

---

Ninja's_RGR'us (1/3/2012)

---

Turns out it was another mistake (big one, but not as big). He had left live vm snapshots on for 2 weeks. Managed to fill up...

GilaMonster (1/3/2012)

---

No, no, no, no, no!

And on a...