Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,961 through 33,975 (of 59,099 total)

RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/11/2011)
Jeff Moden (5/10/2011)
Pete,
Based on the findings in the post above, will you ever have a condition where the first character isn't a letter?
Jeff -- the first character should just...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 11, 2011 at 8:03 am

#1323035
RE: Get the First letter of each word within a string and returned a concatenated string

garima.khandelwal (5/11/2011)
T-SQL program fetching the first character of each word in the given string :
DECLARE @STRING VARCHAR(8000);
DECLARE @Pos int =1;
DECLARE @FINALSTRING VARCHAR(8000) = '';
DECLARE @COUNTER int = 0;
DECLARE @DELIMINATOR VARCHAR(1)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 11, 2011 at 7:47 am

#1323008
RE: Get the First letter of each word within a string and returned a concatenated string

Mark-101232 (5/11/2011)
For completeness, here's a simple SQLCLR to perform the same task, appears to perform okay.
Now we know part of the reason why I usually provide a mountain of generated...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 11, 2011 at 7:36 am

#1322990
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/11/2011)
select * from dbo.Abbreviate(' aaa .. bbb ,, ccccc ') --Result (without ;): &#;x20;
Sory, result text was eaten by some html machinery -...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 11, 2011 at 7:32 am

#1322982
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/11/2011)
Today I can throw only cakes, drinks and ice-cream - my son was just born :hehe:
A very, very special occasion, indeed! Congratulations to you and your Wife,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 11, 2011 at 7:29 am

#1322978
RE: Are the posted questions getting worse?

bitbucket-25253 (5/10/2011)
Jeff Moden (5/10/2011)
Steve Jones - SSC Editor (5/10/2011)
Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 11:56 pm

#1322754
RE: Are the posted questions getting worse?

Koen Verbeeck (5/10/2011)
Jeff Moden (5/10/2011)
Steve Jones - SSC Editor (5/10/2011)
Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 11:53 pm

#1322753
RE: Get the First letter of each word within a string and returned a concatenated string

Pete,
Based on the findings in the post above, will you ever have a condition where the first character isn't a letter?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 9:02 pm

#1322715
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/10/2011)
Jeff, what your function Abbreviate supposed to do ?
It seems to me that it does not do much:
select * from dbo.Abbreviate('aaa bbb ccccc')
Result:
a
It works just fine for what...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 8:37 pm

#1322713
RE: Are the posted questions getting worse?

GilaMonster (5/10/2011)
Steve Jones - SSC Editor (5/10/2011)
Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 12:05 pm

#1322578
RE: manager - employee relationships

SQLHeap (5/10/2011)
Thanks for your responses! I have what I was looking for with your help.
Outstanding! When you get done, would you post your final solution here, please? ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 11:22 am

#1322525
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (5/10/2011)
Just rated some sessions for the PASS Summit. This has to be one of the poorest implementations of a rating tool I've seen, but I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 11:04 am

#1322507
RE: Get the First letter of each word within a string and returned a concatenated string

WayneS (5/10/2011)
FYI, here are the results on my system (with my code throw in to test also):
--===== Test the RBAR function ========================================================================================
Total Duration in Seconds: 12
--===== Test the NON RBAR...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 10:54 am

#1322499
RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/10/2011)
Million thanks, Jeff. I look forward to trying it out your sql solution.
As I'm sure you've heard from many others before, your thoroughness of tackling a problem is really...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 10:51 am

#1322496
RE: Get the First letter of each word within a string and returned a concatenated string

Pete,
Your code is in the reply above. Look for the "dbo.Abbreviate" function.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 10, 2011 at 8:56 am

#1322374

Viewing 15 posts - 33,961 through 33,975 (of 59,099 total)