Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

Chad Crawford (11/8/2010)
Jeff - you replaced a SharePoint 2010 presentation that was moved to Thursday. It seems to have replaced a session on High Performance Functions.
If I'm 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)

November 10, 2010 at 9:58 am

#1249022
RE: Are the posted questions getting worse?

WayneS (11/8/2010)
Forget the online text editor... put it into a word document. Steve will convert it.
I normally just use the online editor to save Steve some time. The conversion...
--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 9:54 am

#1249019
RE: Why SHRINKFILE is a very bad thing, and what to do about it.

chethan.cn (11/8/2010)
hi
Does dbccshinkfile( 'filename',mb) wll take care of fragmentation
Actually, it doesn't. It's a major cause of index and data (clustered index) fragmentation not to mention the fragmentation...
--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 9, 2010 at 8:31 am

#1248340

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