Viewing 15 posts - 8,716 through 8,730 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 1:20 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 1:16 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 12:33 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 12:28 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 12:03 pm
RBarryYoung (8/17/2009)
GilaMonster (8/17/2009)
ta.bu.shi.da.yu (8/17/2009)
For instance, I was asking and saying a lot of dumb things about self-joins and outer joins a few days ago in another thread... 🙂
Those weren't dumb...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 9:54 am
jcrawf02 (8/17/2009)
GSquared (8/17/2009)
ta.bu.shi.da.yu (8/17/2009)
Obviously, the question I saw earlier...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 9:50 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 9:38 am
Ronald Bruintjes (8/17/2009)
jcrawf02 (8/13/2009)
matt stockham (8/13/2009)
jpowers (8/12/2009)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 9:31 am
hshah (8/17/2009)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 8:56 am
Heh... if the eyes reveal the soul, the blog reveals the mind.
I'm nearly blind (can see about 6 inches without glasses), and my blog is empty ... the implications are...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 8:51 am
If you want to remove all spaces, "replace(string, ' ', '')" will do it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 8:47 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 8:42 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 7:34 am
ta.bu.shi.da.yu (8/17/2009)
Obviously, the question I saw earlier (how do...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 17, 2009 at 7:09 am
Viewing 15 posts - 8,716 through 8,730 (of 14,953 total)