Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,346 through 42,360 (of 59,067 total)

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
RE: Need a Line Seperator Between Data

The only problem with that is, stuff doesn't line up when you print action characters.
--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:33 pm

#1037656
RE: Shrinking file grows again

Shrinking the file after doing a reindex just messes things up because the shrink moves pages.
--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:20 pm

#1037649
RE: Need a Line Seperator Between Data

Ok... although a nifty trick, the problem with using something like COMPUTE BY for this is that it returns multiple result sets. I can see the need for this...
--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:03 pm

#1037638
RE: Need a Line Seperator Between Data

JC (8/11/2009)
Thanks Drew
but i guess we differ in opinion as I have been writiung Oracle SQL for many years and I do not quite understand whay i should not be...
--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 11:49 am

#1037631
RE: Need a Line Seperator Between Data

drew.allen (8/11/2009)
You shouldn't be doing formatting in T-SQL. You should be using a formatting tool like SSRS.
You can trick T-SQL into doing this by adding a COMPUTE BY clause...
--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:31 am

#1037583

Viewing 15 posts - 42,346 through 42,360 (of 59,067 total)