Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,271 through 48,285 (of 59,095 total)

RE: Nested Cursors

Thanks, Lynn.
Scott, the article is long because it explains the wrong way to do things as well as the right way. The concept is wicked simple and creating running...
--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 17, 2008 at 7:38 pm

#873339
RE: Add space to a database a little at a time or large chunk?

I concur... basically, auto-growth should never take you by surprise... it should be a planned event and it should be made based on a plan derived from usage patterns. ...
--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 17, 2008 at 7:31 pm

#873337
RE: data error in cursor

joshua.a.anderson (9/17/2008)
wow i'm an idiot. thanks for your help. to bad there is not some gift card service to give to bulletin board members for good help.
LOL! PayPal always...
--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 17, 2008 at 7:13 pm

#873335
RE: Keep first row in grouped data

In that case, please take a peek at the link in my signature. It'll help use help you faster and 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 17, 2008 at 7:10 pm

#873334
RE: Multiple update statements in a script

Triple posted... please click on the user's name to find the other 2.
This is a huge waste... splits the answers to a single problem into 3 different posts. Please...
--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 17, 2008 at 7:07 pm

#873332
RE: Please help: Multiple update statements in a script

Triple posted... please click on the user's name to find the other 2.
This is a huge waste... splits the answers to a single problem into 3 different posts. Please...
--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 17, 2008 at 7:07 pm

#873331
RE: Need help from t-sql experts

Triple posted... please click on the user's name to find the other 2.
This is a huge waste... splits the answers to a single problem into 3 different posts. Please...
--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 17, 2008 at 7:06 pm

#873330
RE: SQL Spelling mistakes

Yeaup... test the first sproc you changed before you promulate the change to 199 others. Simple testing is the best verification tool there is. And, in this case,...
--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 17, 2008 at 7:00 pm

#873327
RE: converting text to int

Jeff (9/17/2008)
I did try that first. It gives the error:
Server: Msg 235, Level 16, State 1, Line 1
Cannot convert a char value to money. The char value has incorrect...
--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 17, 2008 at 6:53 pm

#873323
RE: Keep first row in grouped data

As so many will, undoubtedly, tell you, how do you know what the "first" record really is? There's no guarantee that the order you enter the data will stay...
--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 17, 2008 at 6:35 pm

#873320
RE: Databases for Change

Great article and very well presented as JJ B and a couple of others noted.
I take no offense to building a database of lobbyists, etc... but instead of spending good...
--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 17, 2008 at 6:24 pm

#873318
RE: An interview with the Exceptional DBA of the Year

Outstanding accomplishments, Dan. Well deserved award!
--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 17, 2008 at 6:17 pm

#873316
RE: Patindex

Wayne West (9/17/2008)
Jeff Moden (9/16/2008)
... The real key is that I have a good friend that I argue with/agree with once in a while. He said something I'll never...
--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 17, 2008 at 6:07 pm

#873315
RE: functions

Yeah... I know, Sergiy. Really just wanted you to post it on this thread so others can learn. Thanks. 🙂
--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 17, 2008 at 5:58 pm

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

Thanks, Madhivanan, my old friend. No, haven't written Part II to this article, yet. Got caught up in a new job and can hardly keep up with new...
--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 17, 2008 at 5:56 pm

#873313

Viewing 15 posts - 48,271 through 48,285 (of 59,095 total)