Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,601 through 42,615 (of 59,067 total)

RE: Export to .csv

Heh... Don't do it for me... I actually can't help because I use something else instead of SSIS. It was just an observation that even if someone wanted to...
--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 1, 2009 at 9:31 am

#1033353
RE: Query Help

Slow... I guess I'm trying to juggle too many things at one time. I need to concentrate on "one" of something and get it done. The running total/quirky...
--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 1, 2009 at 8:49 am

#1033341
RE: mdf file increasing rapidly - what are the causes for increasing the mdf file size?

Now that's funny stuff right there... it reminds me of folks that think banging on an elevator button will make the elevator go faster.
--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 1, 2009 at 8:46 am

#1033340
RE: IF Statements affecting performance ?

GilaMonster (8/1/2009)
Jeffrey Williams (7/31/2009)
I don't think IF statements are related to performance at all. Using IF statements is flow control - not processing so there really isn't anything 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)

August 1, 2009 at 8:44 am

#1033339
RE: loop help

Hi Pete,
Ok... but there are better ways to do this. I guess I would first question the requirement of making alpha-numeric keys in the first place. An IDENTITY...
--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 1, 2009 at 8:39 am

#1033337
RE: differiniate quotes as data vs quotes as column identifier

Yep... that should work.
As a side bar, it's been a day or two since this thread has been active and I orginally didn't believe your code would work...
--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 1, 2009 at 8:21 am

#1033335
RE: differiniate quotes as data vs quotes as column identifier

Checking...
--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 1, 2009 at 8:07 am

#1033331
RE: What if we dont end the conversation on the initiator side??

Nah... sorry. Just passing through. I don't even know how to spell "Service Broker".
--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 1, 2009 at 12:06 am

#1033285
RE: Date conversion

I thought most reporting programs had date formatters built in?
No matter... here's how to do it in T-SQL... just keep in mind that it won't be "portable" from country to...
--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 1, 2009 at 12:01 am

#1033283
RE: differiniate quotes as data vs quotes as column identifier

I guess you've lost me a bit... why do you need this to be dynamic SQL? I believe the example code I posted does everything you've asked.
--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)

July 31, 2009 at 11:57 pm

#1033281
RE: Display address in vertical format

arun.sas (7/31/2009)
Hi Jeff,
I think, need the statement for the comma delimited row to the column,
Colin already use the COALESCE statement, actually may Colin need the better one then COALESCE!!!
It looks...
--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)

July 31, 2009 at 11:52 pm

#1033279
RE: How to change license keys for servers on dev edition

I don't believe you need to so long as you have proof that you've purchased the correct number of licenses. Check the EULA to make sure but I believe...
--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)

July 31, 2009 at 10:04 pm

#1033274
RE: Directory of .txt files as Linked Server-confused by column headings.

Hi Jim,
I know you've already solved your problem here but I'm curious. How big are these files? I know you said they've all got 5 columns but how...
--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)

July 31, 2009 at 10:01 pm

#1033273
RE: Learn A Bit More

Heh... I live in Michigan, an Oracle/DB2 state where the weak are killed and eaten. 😛 Most free events are product propaganda here. Even the better ones...
--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)

July 31, 2009 at 9:55 pm

#1033271
RE: Export to .csv

SQLSlammer (7/31/2009)
Here you go
Heh... that does it for me. I couldn't help if I wanted to because you edited the post and removed the package.
Good luck! 😉
--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)

July 31, 2009 at 9:42 pm

#1033269

Viewing 15 posts - 42,601 through 42,615 (of 59,067 total)