Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,086 through 41,100 (of 59,069 total)

RE: REPLACE Multiple Spaces with One

C# Screw (11/19/2009)
Hi folks,
Well this is the 'last post' from me but this is what things look like if there are no double spaces in the data at all:
First, 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)

November 19, 2009 at 6:39 pm

#1081916
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/18/2009)
Ok - it's not prose or rhyme but it is set to Jingle bells
/*
Pouring through the code
of a cursor based stored proc
Making it set-based
Eating a Pork Chop
Set-based procs we...
--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)

November 18, 2009 at 10:36 pm

#1081362
RE: How do I extract numbers from a text field?

Thanks Paul. I found a good one... probably one of the ones that you would have pointed out.
http://msdn.microsoft.com/en-us/library/ms189087.aspx
--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)

November 18, 2009 at 7:08 pm

#1081326
RE: Is C# Better?

Gianluca Sartori (11/16/2009)
rigid languages such as Java simply don't allow crap.
BWAA-HAA!!!! Someone please tell some of the folks I used to work with that!:-P
--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)

November 18, 2009 at 6:09 pm

#1081316
RE: REPLACE Multiple Spaces with One

Paul White (11/18/2009)
Hey everyone, just a quick note before I go to work this morning. I love the way this thread it going - huge thanks especially to C#...
--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)

November 18, 2009 at 1:20 pm

#1081180
RE: REPLACE Multiple Spaces with One

vliet (11/18/2009)
Hello Jeff,
Thank you so much for posting this solution! We will apply your method in a SSIS Derived Column Transformation on data coming from raw files. This data needs...
--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)

November 18, 2009 at 1:15 pm

#1081175
RE: REPLACE Multiple Spaces with One

Michael Meierruth (11/18/2009)
Earlier on in this post I mentioned the use of a binary approach. I finally found some time to try this out.
declare @s-2 varchar(8000)
set @s-2 = '*' +...
--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)

November 18, 2009 at 12:55 pm

#1081161
RE: REPLACE Multiple Spaces with One

C# Screw (11/18/2009)
Jeff,
as promised : all tests combined SQL & CLR
Beginning execution loop
Batch execution completed 10000 times.
SQL:Looping
2536
SQL: using ||*9*9||
6310
SQL: Jeffs single char
2916
CLR: looping
453
CLR: Not looping using ||*9*9|| technique 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)

November 18, 2009 at 12:45 pm

#1081150
RE: Are the posted questions getting worse?

Heh... reminds me of an old joke...
What's the difference between being loyal to a company and being committed to a company?
.... think "Ham and Eggs"....
... the chicken was loyal...
... the...
--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)

November 17, 2009 at 11:25 pm

#1080694
RE: Calculating Work Days

Sorry I didn't have an answer for your previous question, Mac. I sure do appreciate you posting the URL that sorted it for you, though. Thanks for the...
--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)

November 17, 2009 at 11:18 pm

#1080692
RE: Is C# Better?

sjsubscribe (11/16/2009)
GSquared (11/13/2009)
Microsoft has it on their "Will be required in a future version", but doesn't have a date on it yet.
Semi colons are already a requirement for certain idioms...
--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)

November 17, 2009 at 11:14 pm

#1080690
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Martin Butcher-415798 (11/13/2009)
Jeff Moden (11/12/2009)
Ok, Martin... I'm confused... I see that all of your code examples update the "RunningBalance" column... none of the code updates the "RunningTotal" column yet your...
--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)

November 17, 2009 at 10:58 pm

#1080688
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Matt Miller (#4) (11/17/2009)
Hey Jeff!
Truly awesome solution once again! The rewrite is even better than the original.
...
Just wanted to pass this little redirection to you. ( sorry -...
--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)

November 17, 2009 at 10:52 pm

#1080686
RE: REPLACE Multiple Spaces with One

Weeellllll.... that took a bit (a LOT!!!) longer than I thought. I'll try to get to some of my own testing on some of your contributions tomorrow night.
I've got...
--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)

November 17, 2009 at 10:35 pm

#1080684
RE: REPLACE Multiple Spaces with One

Sorry for the delay in my responses to all of this. Heh… you folks look like you had fun without me, though.
I’ll split this response in two… first, my...
--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)

November 17, 2009 at 10:27 pm

#1080681

Viewing 15 posts - 41,086 through 41,100 (of 59,069 total)