Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,036 through 37,050 (of 59,098 total)

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
RE: database mail without cursors?

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).
--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 9:07 pm

#1214023
RE: check if Row exists in the table

SwePeso (8/30/2010)
At least use
SET @CurrencyAmountID = SCOPE_IDENTITY()
instead of
SET @CurrencyAmountID = @@IDENTITY
@@IDENTITY will give you the latest created identity value in the database, no matter which table or user created it....
--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 7:20 pm

#1214011
RE: How to Tune Data Inserts

Mr.SQL DBA (8/30/2010)
Jeff,
You are absolutely correct. Tuning of Inserts is as Important as Tuning the Selects.
so i want any options or any types or any methods or any scenarios...
--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 7:16 pm

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

Anthony,
Here's a direct replacement for your sprTablixTest with three very important differences (that you may or may not want)...
1) It creates different data every time you use it instead...
--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 7:09 pm

#1214009

Viewing 15 posts - 37,036 through 37,050 (of 59,098 total)