Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,181 through 45,195 (of 59,095 total)

RE: Query Tune

No problem... looking back at it, I can see how someone might mistake it. Thanks for the feedback, Andrew.
--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)

February 14, 2009 at 5:42 pm

#944171
RE: Group cumulative data

Nice eye, Milla. Guess I need more coffee.
--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)

February 14, 2009 at 5:39 pm

#944168
RE: Actual Reason to Use CLR

mdiaz (10/17/2007)
A real quick and easy way to make a split funciton, that returns records as a table.
Imagine writing that in TSQL???
Heh... sorry... ran into this today and I realize...
--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)

February 14, 2009 at 2:26 pm

#944158
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

I know it's been close to a month and you may have forgotten... do you remember what you did to get it to work out?
--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)

February 14, 2009 at 1:23 pm

#944148
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

Adi Cohn (2/14/2009)
Jeff please don’t get this question the wrong way, but just out of curiosity – Is there anyone in this world that didn’t get your flying pork...
--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)

February 14, 2009 at 12:33 pm

#944139
RE: Query output to txt file & columnheader headers

You bet... thanks for the feedback. Let us know how it works out for you.
--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)

February 14, 2009 at 12:30 pm

#944138
RE: with out using the cursor/while

Lynn Pettis (2/13/2009)
Jeff, I'm not sure if you are right or wrong still. I ran the following and everything ran fine. Can you suggest any other tests 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)

February 14, 2009 at 12:15 pm

#944136
RE: Why do people need to do this?

smunson (1/24/2009)
I understand where you're coming from, but I think the gist of this thread is more related to the reason behind the desire to see order, because what Jeff...
--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)

February 14, 2009 at 12:10 pm

#944134
RE: SQL or Oracle

Roy Ernest (2/13/2009)
Bruce W Cassidy (2/12/2009)
Roy Ernest (2/11/2009)
One thing I have seen is that Unix (Linux or Sco or what ever) has a better File system. This made Oracle much...
--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)

February 14, 2009 at 12:02 pm

#944132
RE: Query Tune

Mike Levan (2/14/2009)
Guys...what do u mean by that.
" this probloem deos not apply to sql 7 or later"
It means that the myth of SELECT/INTO locking sysobjects so it can't 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)

February 14, 2009 at 11:59 am

#944130
RE: how to split following string

bkDBA (2/13/2009)
Jeff, I hear a non-RBAR solution coming... anyway, thanks for the awesome presentation last night at the SEMSUG at Microsoft!
I had a RBAR "discussion" with...
--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)

February 14, 2009 at 11:50 am

#944128
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

gvsriramakrishna,
You must really like pork chops... 😉
--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)

February 14, 2009 at 11:46 am

#944125
RE: Find all rows in a VARCHAR that can't be cast into an INT

Shawn Therrien (2/9/2009)
SELECT * FROM TestScores WHERE Score <> '0' AND ISNUMERIC(Score) = 0
Worked perfectly.
Thank you sir. Always a good day when I learn how to do away with...
--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)

February 14, 2009 at 11:34 am

#944123
RE: Convert Interger Time to 00:00:00

Vivien Xing (2/13/2009)
My test shows 50% : 50% execution plan cost for these 2 codes.
create table mytest (mytime int)
insert mytest values (91700)
insert mytest values (212000)
insert mytest values (90200)
insert...
--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)

February 14, 2009 at 11:21 am

#944121
RE: 1-M join, concat all records

Then, I think Andrew's solution may be the best. If it was a text file input, you could simply do a BCP out using a simple SELECT and use...
--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)

February 14, 2009 at 10:20 am

#944106

Viewing 15 posts - 45,181 through 45,195 (of 59,095 total)