Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,371 through 35,385 (of 59,099 total)

RE: Upper/lower case text

mister.magoo (1/14/2011)
Jeff Moden (1/14/2011)
Lowell (1/4/2011)
this is the ProperCase function I use; it's from a post by Jeff Moden, i believe, harvested long long ago.
This may be the source....
http://www.sqlservercentral.com/Forums/FindPost644446.aspx
Thanks, Magoo...
That's a...
--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)

January 14, 2011 at 8:56 pm

#1273870
RE: Upper/lower case text

Jeff Moden (1/14/2011)
Wow! I just took a closer look at the code above. If I actually was the one who wrote that, I'm awfully sorry. :sick: ...
--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)

January 14, 2011 at 8:45 pm

#1273869
RE: Upper/lower case text

Lowell (1/4/2011)
this is the ProperCase function I use; it's from a post by Jeff Moden, i believe, harvested long long ago.
you can search for "ProperCase" or "InitCaps" here on SSC...
--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)

January 14, 2011 at 7:00 pm

#1273862
RE: Upper/lower case text

mister.magoo (1/4/2011)
As you only have three small strings to make initial caps I would personally stick with your first thought....
UPDATE dbo.wce_contact
SET
firstname= STUFF (lower (firstname), 1, 1, UPPER...
--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)

January 14, 2011 at 6:31 pm

#1273859
RE: Are the posted questions getting worse?

Gianluca Sartori (1/14/2011)
Roy Ernest (1/14/2011)
Jeff Moden (1/13/2011)
Roy Ernest (1/13/2011)
This place rocks... I ask for help and I get tons of help. This is the second time I asked for help...
--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)

January 14, 2011 at 6:26 pm

#1273858
RE: Proc Performance

TheSQLGuru (1/14/2011)
I have gotten 5 orders of magnitude performance improvement by using...
I absolutely agree that properly written dynamic SQL can beat the tar out of most "catch all" code as...
--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)

January 14, 2011 at 6:18 pm

#1273857
RE: Please help with SQL code

pwalter83 (1/14/2011)
Hi Jeff,
Here is the updated scenario:
If POL_COUNTRY_CD or POD_COUNTRY_CD in NCV_BL_DHL_TEMP table begins with FR, then use POL_Location_CD / POD_Location_CD and join to MG_LOCATION table to identify continent. If...
--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)

January 14, 2011 at 6:13 pm

#1273856
RE: Are the posted questions getting worse?

LutzM (1/14/2011)
Jeff Moden (1/13/2011)
LutzM (1/13/2011)
Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.
I don't suppose there's a chance of doing...
--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)

January 14, 2011 at 6:01 pm

#1273855
RE: Merge performance on Very Large Tables

I'n not sure why but I get an error on the execution plan you attached after saving it and trying to open it. Since you're also using MERGE in...
--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)

January 14, 2011 at 5:56 pm

#1273854
RE: UPDATE using a self-join

CELKO (1/14/2011)
Since there is a move among MVPs to deprecate this in favor of MERGE and no other product uses it, I would clean up my code and get with...
--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)

January 14, 2011 at 5:52 pm

#1273853
RE: RETURN clause, clarification

You bet... thanks for the feedback.
--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)

January 14, 2011 at 4:51 pm

#1273849
RE: Update query nightmare!

christopher.hawkes (1/14/2011)
Thanks for the reply,
Yep i've tried that and i get the same result, its almost like ignores the previous row as its just been updated?
I've used this type of...
--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)

January 14, 2011 at 3:09 pm

#1273827
RE: T-sql to loop through all the tables in the database and delete records

Actually, it's not quite so easy to pull off in the presence of DRI. You'll need code to identify dependencies and that's not always the easiest thing to determine.
--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)

January 14, 2011 at 2:52 pm

#1273817
RE: Select column values as comma seperated format

Agreed and thanks for the feedback, Andrew. SQL Server 2000 was quite the bear for things like concatenation. I did come up with a couple of ways to...
--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)

January 14, 2011 at 2:49 pm

#1273816
RE: RETURN clause, clarification

autoexcrement (1/14/2011)
Sorry, this might be my dumbest post yet. But I can't seem to find a simple explanation.
I'm unclear on exactly what "RETURN" does. BoL says it "[immediately] exits...
--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)

January 14, 2011 at 2:45 pm

#1273812

Viewing 15 posts - 35,371 through 35,385 (of 59,099 total)