Jeff Moden

Forum Replies Created

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

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
RE: use a sequence of column values in a query

Heh... in this situation, you're rebuilding the view! It's gonna recompile no matter what... 😉 Works fine in production code especially in 2k where there's no such thing...
--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 8:59 pm

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

Just in case someone wants to "play", here's the Cross Tab code I'm trying to duplicate with a single pivot...
SELECT Company,
Year,
...
--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 8:44 pm

#832437
RE: transpose rows into columns

sriharivittal1 (5/28/2008)
Can some one provide Sample Code?
You want sample code? Then provide some sample data. Please see, read, understand, and follow the article in the link in my...
--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 4:33 pm

#832420
RE: For loop in sql server

venki (6/22/2008)
Do we have for loop or for each statement in SQL Server?
I tried to use the for loop in my stored procedure but I haven't found it's working and...
--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 4:27 pm

#832418
RE: use a sequence of column values in a query

Whether you use SELECT * or not, if you want to see the table changes in a view, you have to recompile the view. Like Barry said, this is...
--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 4:23 pm

#832417
RE: Converting a stored procedure into a View

Save us all some time... post the stored procedure that you're trying to convert into a view.
--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 2:05 pm

#832408
RE: use a sequence of column values in a query

Jeff W...
SELECT * works perfect on these type of "pass through" or "surrogate views". You can go through the process of naming all the columns if you want, but...
--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 1:58 pm

#832405
RE: Query for Huge Tables

Bilal (6/22/2008)
I expect about 1000 rows to return , and their is one type of index defined which is traffic1
each table have millions of records
any thing else ?
Yes...
--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:32 am

#832375

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