Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,761 through 44,775 (of 59,095 total)

RE: sql

It would likely be better if you wrote the spreadsheet to pull from a view or proc using the "external data" features.
--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)

March 6, 2009 at 10:06 pm

#955402
RE: PIVOT query

Bob certainly did that right for the problem given... I'm just concerned about using names which are likely not unique... especially if it's for people's bank accounts. Heh... 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)

March 6, 2009 at 10:02 pm

#955400
RE: Text Parsing TSQL code

Larry Trach (3/5/2009)
Very helpful. Below is a variant that handles space delimited with double quotes around text.
I have to ask why you would return the columns 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)

March 6, 2009 at 9:58 pm

#955399
RE: BCP Format File

Sorry it took me so long to get back to this...
No... no \t's here... I believe this is what you're looking for. Note that the forum ate 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)

March 6, 2009 at 9:28 pm

#955394
RE: how can i avoid cartesian join?

Ya kinda left things hanging here... did that work for you or what? 😉
--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)

March 6, 2009 at 9:03 pm

#955390
RE: Text Parsing TSQL code

Douglas De Ivey (10/17/2004)
No, what you want to do can't be done with SQL2000. You would need to join your 'inpt table' to the output from the function.
Apparently the next...
--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)

March 6, 2009 at 8:59 pm

#955388
RE: Question on following sql

Yep... that's what I do to, Todd... the "habit" I was talking about, though, is the inclusion of the 'U' in the OBJECT_ID function... it's really not necessary.
--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)

March 6, 2009 at 8:47 pm

#955387
RE: Create a daily record from date ranges

...and thank you for the feedback! 🙂
--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)

March 6, 2009 at 8:42 pm

#955386
RE: PIVOT query

Ed (3/6/2009)
Jeff Moden (3/5/2009)
I've gotta ask, Ed... why do you need this type of denormalize output? What is that output going to be used on? I'm asking because...
--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)

March 6, 2009 at 8:31 pm

#955385
RE: Tune Stored Proc

Mike... how long do just one of these take to run?
select count(*) as ControlTotals
from ' + @RevStateDB + '.dbo.Budget1995 where srcflag =...
--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)

March 6, 2009 at 8:16 pm

#955383
RE: Tune Stored Proc

Mike Levan (3/6/2009)
Can i do this through SSIS pkg or BULK Insert to spped up my load.??
Few questions on BULK INSERT
1. Does a user need to be bulkadmin to do...
--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)

March 6, 2009 at 8:04 pm

#955380
RE: Are the posted questions getting worse?

Jeff Moden (3/6/2009)
Bob Hovious (3/6/2009)
Fine then. Me and Roy will just pack up our CTEs and go home.
Got some cold ones? We can look up some old...
--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)

March 6, 2009 at 7:44 pm

#955377
RE: Are the posted questions getting worse?

Bob Hovious (3/6/2009)
Fine then. Me and Roy will just pack up our CTEs and go home.
Got some cold ones? We can look up some old ISO standards...
--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)

March 6, 2009 at 7:43 pm

#955375
RE: Lets help the experts help themselves

Bob Hovious (3/6/2009)
Does that mean all pork chops, katanas, longbows, and trebuchets would have to be checked at the door? Doesn't sound like much of a party...
--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)

March 6, 2009 at 7:39 pm

#955374
RE: Are the posted questions getting worse?

Bob Hovious (3/6/2009)
Nah.... I'd never get invited.
Seriously, what is to be gained by exclusivity? If you have a complex topic or problem you want to discuss, why 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)

March 6, 2009 at 7:28 pm

#955371

Viewing 15 posts - 44,761 through 44,775 (of 59,095 total)