SanDroid,

I haven't been as active on the forums this past year. I'm curious if you have tried submitting a QotD? If not, perhaps it's time to give it...

Here is one way to accomplish this task (which, by the way I did on SQL Server 2008 R2):

create table dbo.PersonFruit (

Person varchar(10),

...

SQLRNNR (8/11/2011)

---

Evil Kraig F (8/11/2011)

---

SanDroid (8/11/2011)

---

Learning and helping others is very important. I am only a Microsoft Certified Trainer and Red Cross Volunteer. When teaching classes I do not...

SQLRNNR (8/11/2011)

---

Lynn Pettis (8/11/2011)

---

Forever it won't dominate your destiny. Life there is after the dark side.

I was going to wait until tomorrow night, but it is close enough.

I am...

My commute will be getting a little longer in a couple of weeks.

Forever it won't dominate your destiny. Life there is after the dark side.

I was going to wait until tomorrow night, but it is close enough.

I am resigning my position...

Sorry, your right. Must learn to go to bed when tired.

john9569 (8/10/2011)

---

Greetings,

I need your expertise on my issue. I do two tables, each has only one simple column (varchar(500) type). Also, each table has roughly about 4 million...

Most of my jobs were fairly close, 5 minutes to 30 minutes. That, of course, doesn't include the two jobs I held between November 1989 and March 2005.

The first...

My only concern would be if any of the tables contained columns defined as text or ntext.

drew.georgopulos (8/10/2011)

---

there's a lot of funk in the sprocs, so i uploaded them too.

im sure the examples' submission could be improved, but i hope they are adequate to illustrate the...

Tom.Thomson (8/9/2011)

---

Lynn Pettis (8/9/2011)

---

Just thought it interesting regarding the MVP thread, that when he felt I was attacking him, he would respond. I apologized, just as I said...

That's why I haven't said anything more there and simply moving onward.

If you haven't solved this problem yet, would you please post the actual CREATE PARTITION FUNCTION that you used?

Just thought it interesting regarding the MVP thread, that when he felt I was attacking him, he would respond. I apologized, just as I said I would if...