This will do what you're asking:

declare @Name varchar(100);

select @Name = 'Charles Smith';

select reverse(upper(left(reverse(@Name), charindex(' ', reverse(@Name)))));

As mentioned, this won't do what you need, because it'll fail the first time someone...

In cases where there are critical subtables, it's a good idea to include their definitions and sample data for those too.

Without that, I can't test any of this, and that...

There are several possibilities. For example, the database could be in single-user mode, and there could be some user with an open connection. That "user" could be SQL...

It looks like a fair amount of consolidation could be done on the proc to make it more efficient. For example, there are several update statements early on that...

As far as certs for 2005 vs 2008 go, it's doubtful someone would discount a 2008 cert if they're running 2005.

First, certs are really mainly a way to get in...

RBarryYoung (8/17/2009)

---

GilaMonster (8/17/2009)

---

Those weren't dumb...

jcrawf02 (8/17/2009)

---

GSquared (8/17/2009)

---

ta.bu.shi.da.yu (8/17/2009)

---

I'm curious as to what would be seen as a dumb question that is acceptable, and a dumb question that isn't acceptable?

Obviously, the question I saw earlier...

Like Steve, I'm not sure why you'd have separate tables for projects and jobs if it's a 1:1 relationship. There are reasons to do that kind of thing, mainly...

Ronald Bruintjes (8/17/2009)

---

jcrawf02 (8/13/2009)

---

matt stockham (8/13/2009)

---

jpowers (8/12/2009)

---

Personally, I would prefer to pay only for the channels I watch. I see no reason why they can't allow us to pay just...

hshah (8/17/2009)

---

Nice link.

So if i am buying books or enrolling myself on a training course and aiming for some certification (MCTS eventually before i get my first dba job i...

I'm nearly blind (can see about 6 inches without glasses), and my blog is empty ... the implications are...

If you want to remove all spaces, "replace(string, ' ', '')" will do it.

I view every discussion on this site's forums as "networking". It's not just about who you know for a new job, it's also about who you know that you...

The first question is what aspect of DBA work are you interested in? Coming from your background, I'd assume actual administration, as opposed to writing database software, but that's...

ta.bu.shi.da.yu (8/17/2009)

---

I'm curious as to what would be seen as a dumb question that is acceptable, and a dumb question that isn't acceptable?

Obviously, the question I saw earlier (how do...