Alvin Ramard (4/7/2010)

---

GSquared (4/7/2010)

---

When The Thread has more posts than Steve, does that mean it gets to be the editor for...

I always prefered "(s)he/it". Works better when you pronounce it all as one word.

When The Thread has more posts than Steve, does that mean it gets to be the editor for the site?

I used to play with model rockets. Does that count?

It should be based on the expected growth of the database, and on minimizing file fragmentation.

Leaving it at the default 10% is a good way to end up with all...

Do you have a "Person ID" or something of that sort, or just first and last name?

If it's just by name, then you can change the Partition By portion of...

In SQL 2005 and later, I usually use Row_Number and a CTE to do that.

Something like this:

;

WITH CTE

...

You could use NullIf. Would that do what you need?

Pranav Shah-410191 (4/7/2010)

---

I am sorry, but I didn't mean to say that SQL Server is the problem. I just did a quick personal comparison on how it is different...

Pranav Shah-410191 (4/7/2010)

---

Thanks for the info.

I was thinking of SQL Server has more limitations than I had initially thought of. In that case I will just end up writing some...

Me! (Okay, that's a lie.) 😀

phiren (4/6/2010)

---

Our department does not create or support those Access databases. Users can use Access to do whatever that they want to do with the data once they link...

RBarryYoung (4/7/2010)

---

ghostdance1969 (4/6/2010)

---

OMG..............I feel so stupid, lmao............

I can't believe I overlooked that this whole time.

Thank you so much

By the way I read alot of your replies helping others, you're pretty...

ghostdance1969 (4/6/2010)

---

OMG..............I feel so stupid, lmao............

I can't believe I overlooked that this whole time.

Thank you so much

By the way I read alot of your replies helping others, you're pretty impressive,...

Alvin Ramard (4/6/2010)

---

GSquared (4/6/2010)

---

Since I'm closing in on SSChampion, it's...