Barry, I appreciate you looking into this. Take care of yourself first, and come back to this when you're up to it.

That "tough problem" part intrigues (and scares) me. If...

Not necessarily. If your 2000 db has features that have been removed, then those won't work.

I suggest that you run the Upgrade Advisor against the database to see what it...

and if you want it cheaper than $49, try here

The biggest issue that I've seen with 64-bit hardware isn't with the database... that will work just fine. My problem has been with SSIS not having access to drivers to...

RBarryYoung (8/17/2009)

---

Thanks Wayne, Jeff.

I played around with it a little using what I felt was more naturally distributed data (making some schools much more popular than others) and it seems...

Just want to point out that you are using the BETWEEN operator with a date field... if your date field can have time values in it, then you probably are...

Barry,

Nice... real nice. I like the approximate number calc, which was what I was missing.

I did run into one issue in implementing it... and it's my fault. The data...

RBarryYoung (8/14/2009)

---

Oops, my...

I've played around a bit with John's suggestion. I've come up with a cursor-based solution, but I can't figure out a set-based solution. I think the problem is that I...

john.arnott (8/10/2009)

---

If I understand this correctly, your final selection of three board members for a candidate could be the first three rows of an intermediate resut (one of your CTE's...

http://summit2009.sqlpass.org/AboutSummit/ROI/BestThingWinners.aspx

TAman (7/29/2009)

---

I'm not sure what you are representing when you say "stuff"("stuff"

And what does the '00000' represent?

Select *

,stuff(stuff(right('00000' + cast(TimeValue...

Hi Sam,

I wrote this script to run along with this one: http://www.sqlservercentral.com/scripts/deadlock/66808/

If you have an active deadlock server-side trace running that has the word "Deadlock" in the output file, then...

shannonjk (7/22/2009)

---

Hello everyone.

I have a bit of a challenge I am attempting to resolve but keep coming up at dead ends.

I have an Invoice table that once the...

Hi SqlBuddy,

Do you happen to have any microsoft (preferred, or any other) links / white papers saying this?...