Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,561 through 43,575 (of 59,101 total)

RE: sql server error

Brainy,
Gail's answer is the method I use if I have to do something like this (rare, usually wrong thing to do, but sometimes similar thing correctly happens on maintenance scripts)....
--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)

June 7, 2009 at 12:40 pm

#1005850
RE: charindex help

Thanks for the awesome feedback, John. I really appreciate it.
Thanks for including an explanation, as well. I normally try to explain the code for the OP in the...
--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)

June 6, 2009 at 6:44 pm

#1005762
RE: Are the posted questions getting worse?

David Burrows (6/6/2009)
But more time for the deflected rebound to smack you in the face 😛
BWAA-HAA!!! There in lies the secret... you have to learn how to catch them...
--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)

June 6, 2009 at 4:29 pm

#1005761
RE: Are the posted questions getting worse?

Yep... found it that way in 2k5, as well, just like Paul said. As Gail pointed out, they still haven't said anything explicit about using a table alias as...
--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)

June 6, 2009 at 1:50 pm

#1005756
RE: What SQL Server Sites do you use?

Lynn Pettis (6/6/2009)
Jeff Moden (6/5/2009)
99.99% SQLServerCentral.com - I like folks like you and the others I've come to know and some of the other sites just seem to bloody rude...
--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)

June 6, 2009 at 1:42 pm

#1005755
RE: Are the posted questions getting worse?

GilaMonster (6/6/2009)
Jeff Moden (6/6/2009)
Gail's BOL link doesn't work for me when I paste it into the help URL field. I'm still using 2k5 if that matters.
It does matter. That...
--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)

June 6, 2009 at 1:25 pm

#1005754
RE: Are the posted questions getting worse?

Paul White (6/6/2009)
BTW on behalf of Cancerians everywhere, what's all this with the crabbin'??? 🙂
BWAA-HAA! It's just me trying to get used to the kinder words so I...
--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)

June 6, 2009 at 1:17 pm

#1005752
RE: Are the posted questions getting worse?

Paul White (6/6/2009)
I deliberately said 'not well documented' because I had seen it in BOL - see Gail's post for the link. It's just in totally the wrong place,...
--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)

June 6, 2009 at 9:15 am

#1005726
RE: Are the posted questions getting worse?

GilaMonster (6/6/2009)
WayneS (6/6/2009)
You know, it's always those complex T-SQL concepts that trip up so many people.
Good going Gail!
I know. Those darned updates are just so hard to understand. :hehe:
Correct link...
--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)

June 6, 2009 at 8:56 am

#1005718
RE: Are the posted questions getting worse?

GSquared (6/5/2009)
Just remember, your porkchop delivery method needs to be scalable for that kind of thing. After all, you of all people wouldn't want to accidentally end up with...
--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)

June 6, 2009 at 8:43 am

#1005711
RE: Are the posted questions getting worse?

Paul White (6/6/2009)
The requirement to alias a table variable for UPDATE is not spectacularly well documented in BOL. A quick skim over the entry for the UPDATE statement revealed...
--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)

June 6, 2009 at 8:41 am

#1005710
RE: Sum of top n rows

Amazing... what the hell did the boys in Redmond do? The code posted above by arijit works just dandy in 2k5. The error appears when you try 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)

June 6, 2009 at 12:14 am

#1005644
RE: Parameters

keywestfl9 (6/5/2009)
region will also be a parameter
Heh... I knew that. What do you want done with it? You didn't list it in any of the conditions you've laid...
--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)

June 6, 2009 at 12:07 am

#1005643
RE: Use of FLOAT (or REAL)

Depending on what you're doing, FLOAT can be great. For example, if you add 1/3 three times, you should end up with a nice solid "1", right? Well,...
--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)

June 5, 2009 at 11:13 pm

#1005641
RE: Article Download

Dear RedGate,
I absolutely agree with what Ravi said except for that being the only missing functionality. Code windows that actually work correctly with Internet Explorer would be nice, too....
--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)

June 5, 2009 at 10:56 pm

#1005637

Viewing 15 posts - 43,561 through 43,575 (of 59,101 total)