Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,106 through 36,120 (of 59,102 total)

RE: Are the posted questions getting worse?

Paul White NZ (11/11/2010)
Did you also bust the myth that table variables are always estimated as containing one row?
Statement level recompile?
--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)

November 12, 2010 at 8:18 am

#1250044
RE: Week Part

Hmmmm... you know... we run across this type of thing often enough... perhaps an "SQL Spackle" article is in order.
--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)

November 12, 2010 at 8:06 am

#1250033
RE: Week Part

WayneS (11/11/2010)
Well done Jeff. I turn the podium back over to the master.:-D
Shucks :blush:... you folks are doing just fine and it's a pleasure to be in your good company....
--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)

November 12, 2010 at 8:05 am

#1250032
RE: Travel Planner SQL

My apologies... I just don't understand the problem. Please see my previous comment.
--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)

November 11, 2010 at 7:28 pm

#1249798
RE: week days

selvamariappan (6/20/2008)
How to find the week days in a month using sql server 2005
thanks in advance
selva mariappan
There are a couple of solutions on this thread now. I'd respond except...
--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)

November 11, 2010 at 7:19 pm

#1249797
RE: Week Part

Perhaps the following code will make it easier to explain what was going through my head when I wrote the forumula. A couple of big hints here is 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)

November 11, 2010 at 6:45 pm

#1249793
RE: Week Part

Thanks for the feedback, John. You had the right idea... I just turned it into a formula.
--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)

November 11, 2010 at 8:56 am

#1249545
RE: Week Part

Thought I'd throw my 2 cents in. This eliminates the need for a function altogether.
SELECT Item,
EndOfWeekDate = d.EoW,
...
--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)

November 11, 2010 at 8:45 am

#1249541
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/10/2010)
BTW, I had the chance to meet Jeff in Seattle and it was a pleasure. The rest of you should try to look him up...
--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)

November 10, 2010 at 11:15 am

#1249071
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/10/2010)
Jeff Moden (11/10/2010)
I guess the next question to ask is, has anyone written a "spackle" article (think "Requested Article") on how to return the top...
--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)

November 10, 2010 at 11:13 am

#1249069
RE: Are the posted questions getting worse?

Craig Farrell (11/10/2010)
Jeff Moden (11/10/2010)
Craig Farrell (11/9/2010)
And back on topic for the thread:
http://www.sqlservercentral.com/Forums/Topic1018016-338-1.aspx
*wallbanger*
I'll be "blah blah"ing over in the corner now.
As I said on that post... now I know what...
--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)

November 10, 2010 at 11:11 am

#1249067
RE: Using the salary table on the left, write a SQL Server T-SQL query to find the Top 2 salaries for each employee. The result of the query is on the right.

Geoff A (11/10/2010)
Jeff Moden (11/10/2010)
Yowch! So that's what a feeding frenzy on a newbie looks like from the outside. Lesson learned for me. 😉
so you can teach an...
--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)

November 10, 2010 at 10:49 am

#1249054
RE: Are the posted questions getting worse?

I guess the next question to ask is, has anyone written a "spackle" article (think "Requested Article") on how to return the top 2 items from each group, yet?
--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)

November 10, 2010 at 10:42 am

#1249049
RE: Are the posted questions getting worse?

Craig Farrell (11/9/2010)
And back on topic for the thread:
http://www.sqlservercentral.com/Forums/Topic1018016-338-1.aspx
*wallbanger*
I'll be "blah blah"ing over in the corner now.
As I said on that post... now I know what a feeding frenzy on...
--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)

November 10, 2010 at 10:26 am

#1249039
RE: Using the salary table on the left, write a SQL Server T-SQL query to find the Top 2 salaries for each employee. The result of the query is on the right.

Yowch! So that's what a feeding frenzy on a newbie looks like from the outside. Lesson learned for me. 😉
--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)

November 10, 2010 at 10:15 am

#1249035

Viewing 15 posts - 36,106 through 36,120 (of 59,102 total)