Missed you both, G-Squared and Barry.

Barry, my best wishes go out to you. I hope things improve soon.

BWAHAHAHA.

Jason, I'm going to hurt you...

Aw, lookit all that sugar in that editorial. You so sweet! @=)

The community is definitely fantastic. It has helped me so much over the years. It's nice to be a...

Allergy

Because some people are allergic to pain medications

sqlbi (8/27/2010)

---

Thirdly, the PIVOT is trying to count a column that doesn't exist in your CTE.

---------------------------------------------------------------------------------------------------------------------------

i changed query as you mentioned above but it is saying invalid emailaddrid

with...

At least you're not on a plane, Steve. @=)

Wow, Wayne, that's a majorly cool solution. I like.

The only concern I'd have is scalability, but that's dependent on what the other countries' docs "look like."

EDIT: Then again, I'm...

I'm running a mini session on this for Orlando's upcoming SQL Saturday if anyone's interested. @=)

First, your error message is wrong for your new code. You should be getting 2 errors, not just the 2003 error. And it should be 2009, not 2003, based on...

Ditto on the links thanks. I need to buy myself a copy.

To be fair, there are so many flavors of DBA that architecture / design could be considered part of a DBA's job in certain places.

ACK! We've been invaded! There's one of those non-DBA types on...

Maybe, but ISTR that it was a reference to SQL Server, not the OS. Because there were questions on how to restore SQL Server with various different backup plans.

AhHA! I'm...

Odd. I remember studying incremental backups when I took my SQL 2000 cert test. Maybe 2000 got rid of it and SQL 7 had it, but there were incremental backups...

verbotten