Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,006 through 37,020 (of 59,072 total)

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
RE: Parsing an ADO result set into a comma separated string in SSIS

I'm a bit torn on this one...
The article is nicely written with good clear graphics examples but I just wouldn't do this task this way. On the other hand,...
--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 6:41 am

#1214903
RE: Where Are the Programmers?

Heh... so far as I'm concerned, there really aren't any computer programmers left in most of the world. 😉 There are a whole lot of computer "users" using high...
--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 6:27 am

#1214898
RE: database mail without cursors?

Perfect. I'll be back. Sorry this is taking so long. Work is a bit hectic and the delays between our posts make things a bit slow. ...
--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 6:13 am

#1214889
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

CirquedeSQLeil (1/9/2010)
Nice one Jeff. I missed it the first time around (and never searched for anything that pulled it up here at SSC). Adding this one to 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)

August 31, 2010 at 9:38 pm

#1214715
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Thanks for the feedback, loki1049, and glad I could help. Nicely done and thanks for sharing your code with us. 🙂
--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)

August 31, 2010 at 9:36 pm

#1214714
RE: Pivot w/o aggregation...query not working

Jon V (8/30/2010)
Complicating things is that I have to insert ntext data into another row if a "Not Applicable" answer shows up, appending it from the previous row. Any...
--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)

August 31, 2010 at 9:16 pm

#1214711
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

AnthonyR (8/30/2010)
Hi Jeff,
Using NEWID() as you have is a better way to get random data out of SQL if you don't want repeatability, but getting repeatable random-ish data out 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)

August 31, 2010 at 9:13 pm

#1214710
RE: CTE - How to surpass the limit

I modified the code for the Split8K function further so that it would actually split all the rows thrown at it for shield_21's tests. Here's what it looks like...
--DelimitedSplit8K...
--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)

August 31, 2010 at 9:09 pm

#1214708
RE: CTE - How to surpass the limit

Quatrei.X (8/30/2010)
:w00t: COOL! Thanks a lot everyone.
:hehe: I haven't used SET STATISTICS TIME (ON|OFF) before. Thanks 😀
that's the one you guys used right? or is there a tool or something...
--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)

August 31, 2010 at 8:14 pm

#1214698
RE: Are the posted questions getting worse?

Brandie Tarvin (8/31/2010)
GilaMonster (8/31/2010)
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
ACK! We've been invaded! There's 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)

August 31, 2010 at 7:03 am

#1214240
RE: database mail without cursors?

pietlinden (8/30/2010)
Jeff Moden (8/30/2010)
The only thing I'm missing is how YOU call the EXEC that sends an email for you. (Trying to give you a complete solution).
I would call...
--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)

August 30, 2010 at 10:28 pm

#1214033

Viewing 15 posts - 37,006 through 37,020 (of 59,072 total)