Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,676 through 48,690 (of 59,102 total)

RE: Instead of Using Cursor? Other Ways?

pockeyfan (8/19/2008)
Did you try the function I gave you?
Hi, thanks for your help
However, I could not run your codes in my system. There's always error message shown "Incorrect syntax near...
--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 19, 2008 at 9:58 pm

#860383
RE: My 3rd party softwares uses tons of cursors.

Matt Miller (8/15/2008)
Matt Miller (8/14/2008)
I will see what I can do. I think I might want to try a CLR proc on this one.....
By the way - that was...
--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 19, 2008 at 9:52 pm

#860382
RE: Debugger For SQL

Carl Federl (8/19/2008)
Jeff, regarding the benchmark method you are using, found a curious situation.
If this SQL is run, statistics time reports duration and cpu of of zero:
set statistics time on
insert...
--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 19, 2008 at 9:46 pm

#860381
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jeff Moden (8/19/2008)
Jeffrey Williams (8/19/2008)
Jeff Moden (8/19/2008)Yeap... 'bout six weeks ago if I recall correctly... the only thing missing for me was doing those bloody dual Pivots...
Do 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)

August 19, 2008 at 9:27 pm

#860378
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jeffrey Williams (8/19/2008)
Jeff Moden (8/19/2008)Yeap... 'bout six weeks ago if I recall correctly... the only thing missing for me was doing those bloody dual Pivots...
Do you happen 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)

August 19, 2008 at 9:24 pm

#860377
RE: How to use stored procedure instead of cursors?

charshman (8/19/2008)
No offense Jeff, but I think you're taking the discussion a bit off topic. The original question had nothing to do with cursors as you know them 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)

August 19, 2008 at 9:01 pm

#860375
RE: Loading text file to SQL Server 2005 using bulk insert

Couple of things may be happening here... first off, where is 'c:\SEND\SPF' ?? If it's not on the server, then you have to change the path to a UNC....
--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 19, 2008 at 8:47 pm

#860374
RE: GOTO vs WHILE

DB_Andrew (8/19/2008)
Instead of preaching your “RBAR” cliché and putting people down for doing it the wrong way why don’t you get off your soap box and make yourself helpful for...
--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 19, 2008 at 8:36 pm

#860372
RE: The Basics of Sizing a SQL Server Database

Martin Goebbels (8/19/2008)
Gentlemen, that discussion is very interesting, but I'd like to post another issue:
Now I know the the disk space I need, but and the rest? I mean, 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)

August 19, 2008 at 7:22 pm

#860351
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

There's a bunch of good folks that took the time to "drop in" with some GREAT encouragement and tips on what I'm doing right that I haven't responded to personally......
--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 19, 2008 at 7:00 pm

#860346
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Slope (8/19/2008)
Nicely written article, Jeff! I'm new to this forum so don't know if you've covered it already, but it might be nice to see a counterpart to this...
--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 19, 2008 at 6:56 pm

#860343
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

JJ B (8/19/2008)
Once again, such good explanations/teaching.
I'm like an earlier poster. I haven't been able to find an advantage to the pivot syntax. (Though unpivot came in handy...
--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 19, 2008 at 6:41 pm

#860340
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jack Corbett (8/19/2008)
Thanks Jeff. My blog is http://www.wiseman-wiseguy.blogspot.com. It's also at the bottom of all my posts on the little button that says "blog". 😛
That's where I put...
--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 19, 2008 at 6:35 pm

#860339
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Nicole Bowman (8/19/2008)
Thanks for a very clear article. I have been wondering what the differences might be between cross tab and pivot but haven't found the time to investigate. Now...
--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 19, 2008 at 6:23 pm

#860335
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jeffrey Williams (8/19/2008)
However, if you want dynamic number of years then you are going to need to use dynamic SQL to generate the query. I believe Jeff is going...
--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 19, 2008 at 6:21 pm

#860334

Viewing 15 posts - 48,676 through 48,690 (of 59,102 total)