Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,021 through 37,035 (of 59,098 total)

RE: last value from string

J-F Bergeron (9/3/2010)
You should be able to figure this out... Charindex has an optional parameter, look it up in BOL.
Spot on.
--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)

September 3, 2010 at 1:34 pm

#1216413
RE: How to select top 3 rows and convert the rows to columns for each group

Nicely done, Wayne.
--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)

September 3, 2010 at 1:31 pm

#1216410
RE: Bulk Insert Peformance Question

ackreul (9/3/2010)
Hi Wayne,
Thanks for the response. Correct, I have one flat file that contains a list of paths to other files that need to be loaded into SQL Server....
--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)

September 3, 2010 at 1:29 pm

#1216407
RE: Recursive select using UDF against a table?

rschaeferhig (9/2/2010)
Thanks for the response.
The need for the Leaders table is to define who the Leaders are in the company and certain specific attributes not found in our Employee table...
--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)

September 3, 2010 at 12:41 pm

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

Paul White NZ (9/3/2010)
Hugo,
Excellent, thank you. I do agree (as I have mentioned more than once before on this thread) that the SQLCLR or set-iteration alternatives are a better...
--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)

September 3, 2010 at 7:46 am

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

Hugo... you're recent comments are quite lengthy and deserve a bit of study before further reply. I'll try to do that after work tonight.
--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)

September 3, 2010 at 7:30 am

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

tonyrogerson-498793 (9/2/2010)
I wasn't going to respond because I knew I'd get grief for taking the opposite view to you Paul and Jeff and no doubt a few others that are...
--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)

September 3, 2010 at 7:21 am

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

Hugo Kornelis (9/3/2010)
Jeff Moden (9/2/2010)
No one has yet observed out-of-sequence updates if they've met ALL the rules. That's been since the earliest versions of Sybase and all versions, hot...
--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)

September 3, 2010 at 7:03 am

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

Paul White NZ (9/2/2010)
boudinov (9/2/2010)
Also, is it possible to do Quirky update over a table variable? Is the update sequence guaranteed to be in the order rows were also inserted?
You...
--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)

September 2, 2010 at 6:11 pm

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

boudinov (9/2/2010)
Hi Jeff,
I bet we would love to see "groupings on repeated data such as "Start/Stop" indications over time (although there is a clever way to solve that which will...
--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)

September 2, 2010 at 6:05 pm

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

Hugo Kornelis (9/2/2010)
boudinov (9/2/2010)
Hi Jeff,
I bet we would love to see "groupings on repeated data such as "Start/Stop" indications over time (although there is a clever way to solve that...
--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)

September 2, 2010 at 5:54 pm

#1215994
RE: last value from string

Just a suggestion... Doing 2 or 3 REVERSE's tends to be a bit expensive even compared to an ISNULL/NULLIF combo. If you're guaranteed to always have a comma, then...
--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)

September 1, 2010 at 9:00 pm

#1215375
RE: Recursive select using UDF against a table?

rschaeferhig (9/1/2010)
I have a table of employee IDs. I have a separate function that determines all the employees reporting to a given employee ID. Is there a way I can...
--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)

September 1, 2010 at 1:42 pm

#1215259
RE: Parsing an ADO result set into a comma separated string in SSIS

sknox (9/1/2010)
.... your explanation as to why you did this in SSIS is a great example of how "best" practices sometimes are NOT the best solution for a particular business...
--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)

September 1, 2010 at 1:33 pm

#1215254
RE: Dynamic Columns - Cash Flow problem

Ooooooo... crud. I'm on my way to work and always miss out on the fun stuff. I'll be watching whoever gets to this one. 😛
--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)

September 1, 2010 at 7:22 am

#1214936

Viewing 15 posts - 37,021 through 37,035 (of 59,098 total)