Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,976 through 45,990 (of 59,101 total)

RE: Where 1 = 1

J (1/13/2009)
As far as a server option to make a WHERE clause required, I can see some benefit, but it really is to protect idiots from themselves.
If you type:
[font="Courier New"]DELETE...
--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)

January 13, 2009 at 8:06 pm

#926343
RE: Where 1 = 1

GSquared (1/13/2009)
So, two mistakes, neither of which would have mattered all that much by itself, but together made a problem that mattered, which could have been prevented with a...
--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)

January 13, 2009 at 7:47 pm

#926339
RE: Where 1 = 1

Michael Earl (1/13/2009)
As far as the join style - Jeff, you are crazy. The JOIN keyword is much more readable. Ok, you are not crazy, it is all...
--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)

January 13, 2009 at 7:45 pm

#926338
RE: PRINT statement

Cool... thanks for the feedback, Jason.
--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)

January 13, 2009 at 7:42 pm

#926337
RE: How to loop through different tables to modify a single field?

Felix! Are you all set?
--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)

January 13, 2009 at 7:06 pm

#926329
RE: Don't Let the Economic Downturn Get You Down

Steve Jones - Editor (1/13/2009)
Jeff,
I agree, he's probably not going to get the job, and probably shouldn't, but given the people I've interviewed and talked with others about, maybe he...
--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)

January 13, 2009 at 3:36 pm

#926285
RE: How to go to the next item in a while loop on hitting an error?

Lookup DBCC SHOWCONTIG in Books Online. Example "E" is what you're looking for if you don't mind using cursors. I personally won't use a cursor (including the monster...
--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)

January 13, 2009 at 9:12 am

#926001
RE: How to loop through different tables to modify a single field?

...or just dump it into some dynamic SQL. Or, if the tables change every month, have some dynamic SQL build a proc for you. You can even build...
--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)

January 13, 2009 at 9:07 am

#925995
RE: PRINT statement

The RAISERROR with the NOWAIT clause is certainly a way to do it... and then, you have nothing but something printed on the screen. No way to do 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)

January 13, 2009 at 8:50 am

#925965
RE: Date Range of Week

bdewulf (1/13/2009)
I'm getting an incorrect syntax error when I do From dbo.Calendar. I am using MS Sql 2000 and I don't see this table.
Just to clarify my original post....
--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)

January 13, 2009 at 8:39 am

#925943
RE: The T-SQL Quiz

Grant Fritchey (1/13/2009)
Jeff Moden (1/13/2009)
True enough, 2000 is out of support... now, tell me it's out of use. Hmmm... that would make a good survey question... I'll think there's...
--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)

January 13, 2009 at 8:33 am

#925930
RE: Inserting a value in an ordered string

Mark,
VERY clever code... I obviously never thought of using PatIndex and a variable for the first character of a range... And, it's about twice as fast as the Tally 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)

January 13, 2009 at 7:07 am

#925847
RE: Inserting a value in an ordered string

Mark, if you do a final replace of ")" with "& # 0 4 1 ;" (without the spaces), then your code wil show correctly without all those...
--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)

January 13, 2009 at 6:45 am

#925819
RE: Don't Let the Economic Downturn Get You Down

James Stover (1/10/2009)
Plus, I don't have to put up with the inane performance review. A truly evil piece of work devised by some twisted HR megalomaniac. My only measure 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)

January 13, 2009 at 6:40 am

#925814
RE: Don't Let the Economic Downturn Get You Down

Steve Jones - Editor (1/11/2009)
I'd like to think that's the minority, but who knows. When you're struggling to find a job, you can really be driven to do things. At...
--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)

January 13, 2009 at 6:25 am

#925803

Viewing 15 posts - 45,976 through 45,990 (of 59,101 total)