Jeff Moden

Forum Replies Created

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

RE: count of consecutive value

Yeah... that fixes it... or at least for this particular problem...
;WITH
cteRowNumItem AS
(
SELECT SampleDate,
Item,
...
--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 8:50 pm

#944180
RE: count of consecutive value

Jeff Moden (2/14/2009)
RBarryYoung (1/31/2009)
Heh. You know Jeff, I think that this might change that article that you're writing, just a little bit. I bet you don't mind too...
--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 8:41 pm

#944179
RE: how to split following string

bkDBA (2/14/2009)
Brian Karcher
I'm the IT Manager at Progessive Metal.
Thanks, Brian. My short term memory is pretty well shot... correct me if I'm wrong, please... you weren't one of 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)

February 14, 2009 at 8:18 pm

#944177
RE: count of consecutive value

RBarryYoung (1/31/2009)
Heh. You know Jeff, I think that this might change that article that you're writing, just a little bit. I bet you don't mind too much though....
--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 8:11 pm

#944175
RE: SQL or Oracle

Max (2/14/2009)
I thought people got that impression because Unix was a slim, unbloated platform whereas windows was FAT :w00t:
😛
--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 6:03 pm

#944173
RE: One time update

It's obvious that you took the path to the dark side or you would have simply said that you used the Identity column. World of hurt awaits you 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 6:01 pm

#944172
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

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