Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,376 through 42,390 (of 59,102 total)

RE: SQL w/ MAX function does not work

Matt Miller (8/11/2009)
Did I miss the part which explains what doesn't work? Sorry if I'm being dense- I just don't get a good understanding of what is not happening....
--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 11, 2009 at 10:18 pm

#1037830
RE: SQLServerCentral Editorial Policy - Article Publication

Steve Jones - Editor (8/11/2009)
In terms of deciding what should be published, I'm concerned someone writing about transaction logs might get shut down. Volunteers would say (for example) that Gail...
--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 11, 2009 at 10:14 pm

#1037828
RE: SQLServerCentral Editorial Policy - Article Publication

Fal (8/11/2009)
My thoughts on a workable solution would be to have a “Pending Articles” page or similar, where volunteer reviewers could post comments. Those could be the basis 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)

August 11, 2009 at 10:06 pm

#1037825
RE: Using a subquery in select list with a GROUP BY clause?

pwatson (8/10/2009)
Hi, thanks for the response. I managerd to sort my problem out by using a view instead. The code's a bit convoluted so I think it's best...
--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 11, 2009 at 6:55 pm

#1037798
RE: There's a Lot to Learn From Even Simple Puzzles

Phil had mentioned something about the documentation in my code... It's nothing compared to the absolutely incredible documentation that some others included in their code. For example, you could...
--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 11, 2009 at 6:43 pm

#1037797
RE: converting String to Number

You have roughly 156 posts as of now... that means you're not really a newbie anymore and you've seen it said before... read the article in the first link 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 11, 2009 at 6:33 pm

#1037796
RE: Bulk Insert does not read entire csv file.....

Eric,
Bit Bucket wanted you to post the code for the function that creates the path in the FROM clause of the BCP statement... not all the stuff you've already...
--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 11, 2009 at 6:19 pm

#1037794
RE: WORD UP!

Heh... crud. False alarm. It was a coincidence... I just did the same delete again and Word still came up properly. Dang...
--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 11, 2009 at 5:58 pm

#1037791
RE: WORD UP!

Yowch! Thought I'd give a little feedback on this nasty little problem. I found the cause... I'm one of those folks that does things like reject cookies and...
--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 11, 2009 at 5:49 pm

#1037789
RE: 'Add' to a character.

saivko (8/11/2009)
What methods don't use explicit transactions?
On most systems, everything is an "implicit" transaction and you have to use a BEGIN TRANSACTION to start an "explicit" transaction.
I'm also not...
--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 11, 2009 at 5:33 pm

#1037787
RE: SQLServerCentral Editorial Policy - Article Publication

timothyawiseman (8/11/2009)
Steve Jones - Editor (8/11/2009)
What I would be happy to do is publish a list of "reviewers" on the writer's page and allow authors the ability to private message...
--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 11, 2009 at 3:42 pm

#1037765
RE: SQLServerCentral Editorial Policy - Article Publication

Steve Jones - Editor (8/11/2009)
I think that ideally more review helps, but as you can see from the discussions yesterday, there is disagreement from reviewers about what is correct, or...
--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 11, 2009 at 2:07 pm

#1037709
RE: PIVOT problem : produces multiple lines

gah (8/11/2009)
Hi you have posted this in the SS2K5 forum but you have a TIME datatype...I dont think this was introduced until SQL 2008...
If I run this on 2K5 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 11, 2009 at 1:46 pm

#1037697
RE: SQLServerCentral Editorial Policy - Article Publication

timothyawiseman (8/11/2009)
Personally, I am a big fan of this site exactly as it is and have great respect for what it has accomplished.
I absolutely agree... I just got...
--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 11, 2009 at 1:36 pm

#1037690
RE: Are the posted questions getting worse?

Luke L (8/11/2009)
BTW it's a Belgian Abbey-style Dubbel.
Heh... the acronym for that is pretty BAD. 😛
--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 11, 2009 at 12:54 pm

#1037669

Viewing 15 posts - 42,376 through 42,390 (of 59,102 total)