Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,786 through 49,800 (of 59,099 total)

RE: Pivot... I don't think it's possible...

That really puts the stuff on the Pivot method, huh? 🙂
--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)

June 23, 2008 at 8:46 am

#832749
RE: Pivot... I don't think it's possible...

Same conclusion I came to... Thanks Peter. It also means that it could be done using a CTE with the same performance if the data is pre-aggregated like 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)

June 23, 2008 at 8:26 am

#832733
RE: Pivot... I don't think it's possible...

It's funny how changing the CTE into a derived table improved performance like that. I'll dig into that and see why.
--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)

June 23, 2008 at 8:06 am

#832703
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Ian Crandell (6/23/2008)
Jeff Moden (6/23/2008)[hrIt was designed as a replacement for OTTO Fuel II which is what the Navy is currently using. OTTO Fuel II has a couple 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)

June 23, 2008 at 8:01 am

#832692
RE: sa removal

gregers65 (6/23/2008)
My approach to being a DBA is that I am here to protect the companies data. These to me means that no one ever uses the sa account...
--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)

June 23, 2008 at 7:53 am

#832682
RE: sa removal

Manoj (6/3/2008)
You Should not be able to Delete SA login from the server, But you could be able to DISABLE the SA account from the server.
Cool... how would you go...
--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)

June 23, 2008 at 7:51 am

#832676
RE: Pivot... I don't think it's possible...

Heh... I wonder if the use of UNPIVOT constitutes cheating too much in this case?
Still, some awesome code... Thanks Jeff W and Peter. I really didn't think it could...
--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)

June 23, 2008 at 7:49 am

#832674
RE: Pivot... I don't think it's possible...

Haven't checked it for accuracy, but that's more like it... getting real close to the Cross Tab version of the code for performance. Thanks, Peter.
--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)

June 23, 2008 at 7:44 am

#832666
RE: Forum Etiquette: How to post data/code on a forum to get the best help

jcrawf02 (6/23/2008)
Nothing is new under the sun, Jeff. Experts are expert by being able to concisely compile information and explain something, not necessarily make it up.
I'd buy 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)

June 23, 2008 at 7:38 am

#832660
RE: Pivot... I don't think it's possible...

Peso (6/23/2008)
You didn't dare to post the question on "the other forum"? 😀
Nah... I knew great minds like yours would eventually show up... Besides... I didn't want to get one...
--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)

June 23, 2008 at 6:49 am

#832613
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Anirban Paul (6/23/2008)
Jeff I believe you are tired of getting words like 'Excellent', 'Awesome', 'Great', etc for your. So I will suggest you this time one thing. Start writing books...
--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)

June 23, 2008 at 6:00 am

#832591
RE: Pivot... I don't think it's possible...

Jeffrey Williams (6/22/2008)
Okay, it can be done in a single pivot - but I had to cheat and performance will probably suffer. As far as I have been able...
--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)

June 23, 2008 at 5:42 am

#832578
RE: Pivot... I don't think it's possible...

rbarryyoung (6/22/2008)
Jeff Moden (6/22/2008)
I'm trying to find out if there's a way to do it using a single Pivot.
Heh. What were we saying just yesterday about posters and their...
--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)

June 23, 2008 at 5:22 am

#832565
RE: Pivot... I don't think it's possible...

Jeffrey Williams (6/22/2008)
I don't think it is possible - and, you have to use the derived table (or a CTE) or you get some very interesting results. Try 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)

June 23, 2008 at 5:18 am

#832561
RE: Pivot... I don't think it's possible...

Thanks, Jeff! Great example of how to do it with 2 derived tables... 🙂
Does anyone know how to do it using a single pivot or are we relegated 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)

June 22, 2008 at 9:50 pm

#832447

Viewing 15 posts - 49,786 through 49,800 (of 59,099 total)