Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,496 through 36,510 (of 59,067 total)

RE: bcp question

SQL_Quest-825434 (9/24/2010)
sqlapprentice (9/24/2010)
sjimmo (9/24/2010)
The problem lies in that fact that xp_cmdshell does not recoginize lang windows paths but we can still use shortend path names with tilde (~) in them.
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)

September 30, 2010 at 10:46 pm

#1230025
RE: Concatenate Results in Row

sinureddi (9/27/2010)
Hi,
Just out of curiosity....
Why is data concatination, just for the sake of "being displayed in the front end", being achieved at the database level. Is this not tying up...
--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)

September 30, 2010 at 10:36 pm

#1230024
RE: concatenating CASE stmt results

Chris Morris-439714 (9/21/2010)
drew.allen (9/21/2010)
Jeff Moden (9/20/2010)
I don't like the short version at all because it "lies".
That's very interesting, but, realistically, how often do people use nondeterministic functions like NEWID() 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)

September 30, 2010 at 10:27 pm

#1230023
RE: D: drive is full and transaction log is full

Ninja's_RGR'us (9/22/2010)
Go in your settings and select 50 posts per page rather than 10. That's take it down to 2 prints!
Topic options, print topic. No need to change...
--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)

September 30, 2010 at 10:19 pm

#1230021
RE: CTE - How to surpass the limit

Sorry... brain freeze... I already responded to this thread.
--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)

September 30, 2010 at 10:11 pm

#1230019
RE: Data Type and Length

David Data (9/27/2010)
But I am curious as to why a VARCHAR(MAX) string that happens to contain say 100 chars is so much slower that a VARCHAR(100) that does? Its...
--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)

September 30, 2010 at 10:05 pm

#1230016
RE: Dynamic columns in ssrs

cpinky01 (9/22/2010)
THANKS FOR REPLYING ME.
THIS I AHVE ACCOMPLISHED BY WRITING THE QUERY THAT RETURNS THE WAY I WANTED IN THE REPORT.
Thank you
Could you post it so we can all see?
--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)

September 30, 2010 at 9:52 pm

#1230014
RE: Export SQL Database to flat file with header(column) name

kailash.vicky2004 (9/29/2010)
rbamania (6/24/2008)
hi,
i have tried bcp, it can dump only table data from sql to txt file- i need column name too. Is their any way to get column 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)

September 30, 2010 at 9:48 pm

#1230011
RE: fn_fixeddrives() : an alternative for xp_fixeddrives

David BAFFALEUF (9/24/2010)
Hi Larry,
Thanks for your comments,
As blessonblessons says, you'll have to use the fully qualified name to be able to call the function from any other database.
It had...
--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)

September 30, 2010 at 9:45 pm

#1230010
RE: I need some help with a test, please.

Ah... by the way. The BETWEEN 1 AND... was to make sure that the code worked correctly just in case someone had a Tally Table of their own 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)

September 30, 2010 at 9:36 pm

#1230008
RE: I need some help with a test, please.

Jeff Moden (9/30/2010)
steve-893342 (9/25/2010)
My conversation with Jeff was getting rather tall!
Heh... I've gotten way behind on things and I'm really tired this last week. Too many fires with sticks...
--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)

September 30, 2010 at 9:32 pm

#1230007
RE: I need some help with a test, please.

Paul White NZ (9/24/2010)
steve-893342 (9/24/2010)
Unless BETWEEN is more efficient here, you just need the LESS THAN
I tend to agree. I'm patiently waiting for Jeff to post the new Tally...
--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)

September 30, 2010 at 9:28 pm

#1230006
RE: I need some help with a test, please.

steve-893342 (9/25/2010)
My conversation with Jeff was getting rather tall!
Heh... I've gotten way behind on things and I'm really tired this last week. Too many fires with sticks in 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)

September 30, 2010 at 9:25 pm

#1230005
RE: I need some help with a test, please.

WayneS (9/26/2010)
Jeff - just saw this thread after returning from my vacation. If needed, I can run this on a Vista Ultimate 64-bit laptop, on 2005 / 2008 (not R2)....
--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)

September 30, 2010 at 9:21 pm

#1230004
RE: I need some help with a test, please.

Not a problem, Gail. I know what you've been going through the last couple of weeks. I think I may have enough information on all of 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)

September 30, 2010 at 9:18 pm

#1230003

Viewing 15 posts - 36,496 through 36,510 (of 59,067 total)