Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,331 through 42,345 (of 59,102 total)

RE: differiniate quotes as data vs quotes as column identifier

Post the code you're currently using and let's have a look.
--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 13, 2009 at 10:12 pm

#1039130
RE: SQLServerCentral Editorial Policy - Article Publication

RBarryYoung (8/13/2009)
Jeff Moden (8/13/2009)
You've mistaken what I said but, looking back at it, I can see how. I put no words in your mouth or at least I didn't...
--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 13, 2009 at 10:03 pm

#1039128
RE: SQLServerCentral Editorial Policy - Article Publication

You've mistaken what I said but, looking back at it, I can see how. I put no words in your mouth or at least I didn't mean to... 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)

August 13, 2009 at 9:47 pm

#1039121
RE: SQLServerCentral Editorial Policy - Article Publication

Gift Peddie (8/13/2009)
I am troubled by the lynch mob it kills desire and keeps people away.
As usual, your timing is perfect... I agree that many simply refuse to participate 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 13, 2009 at 9:15 pm

#1039116
RE: Twenty tips to write a good stored procedure

rja.carnegie (8/10/2009)
Last I heard, SELECT @variable1 = expression, @variable2 = expression, ... ; is deprecated.
For me, that would really be a bad thing. Do you happen to have an...
--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 13, 2009 at 8:59 pm

#1039112
RE: Twenty tips to write a good stored procedure

ta.bu.shi.da.yu (8/13/2009)
Well, I guess we'll agree to disagree.
Heh... I can do that.
But I can tell you, it's a royal pain.
Now there's something we can both agree on. 🙂
--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 13, 2009 at 8:42 pm

#1039106
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/12/2009)
And you are right that 10% thought it was a great article and were put down
To be very clear, I never said that. What I said was...
I'd...
--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 13, 2009 at 8:07 pm

#1039103
RE: SQLServerCentral Editorial Policy - Article Publication

Steve Jones - Editor (8/13/2009)
Instead I'd like to have the debate ensue, especially since I think the debate serves to better convince people of good (or bad) ideas than 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)

August 13, 2009 at 7:51 pm

#1039097
RE: 'Add' to a character.

saivko (8/13/2009)
Whatever 'EIN' was (whether recreated or cleared) , it no longer exists as before. It is now a nvarchar calculated from the integer 'ID' column now.
Is...
--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 13, 2009 at 7:13 pm

#1039093
RE: Self Join

Chuck Lucking (8/13/2009)
Thanks Jeff, I was hung up on having to do a self join with ranking to get the order I wanted. Just over engineering on my part....
--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 13, 2009 at 6:36 pm

#1039077
RE: move the files

charipg (8/13/2009)
i want to copy through xp_cmdshell ?
what is the command.............
Charipg,
(Teach a man to fish...) There's a whole "language" for DOS/CMD and a full reference to boot. 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 13, 2009 at 6:27 pm

#1039074
RE: Are the posted questions getting worse?

Grant Fritchey (8/13/2009)
This is going to become a new badge of honor for people going for jobs or qualifying for MVP:
"And this article I wrote was plagiarized five times 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 13, 2009 at 6:07 pm

#1039069
RE: Twenty tips to write a good stored procedure

ta.bu.shi.da.yu (8/13/2009)
Jeff Moden (8/13/2009)
jswong05 (8/13/2009)
True portability is a myth.
True, basic compatibility is expected. Nothing is 100% compatible to another thing.:-P Why don't database vendors got together and make 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 13, 2009 at 6:00 pm

#1039068
RE: SQLServerCentral Editorial Policy - Article Publication

Tim Walker (8/13/2009)
Jeff Moden (8/12/2009)
If you want to reduce this conversation to a "game of egos ... rather than a genuine knowledge exchange" simply by saying so, then you're doing...
--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 13, 2009 at 5:50 pm

#1039066
RE: SQL RECOMMENDATIONS

Great handle, too... My first recommendation is that you change that. I just won't help people with insults built into their chosen forum name.
--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 13, 2009 at 11:53 am

#1038889

Viewing 15 posts - 42,331 through 42,345 (of 59,102 total)