Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,086 through 38,100 (of 59,098 total)

RE: Collapsing a Table

lmu92 (6/6/2010)
@jeff: I'm confused...
When talking about the double row_number approach I was referring to the sample code I provided a few posts back (not the "deep dive" approach though).
It's showing...
--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 6, 2010 at 4:38 pm

#1176905
RE: Duplicate Record

It is possible that someone disabled the unique constraint, added data, and then reenabled the constraint with WITH NOCHECK activated (IIRC).
--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 6, 2010 at 4:32 pm

#1176904
RE: Help with bulk random code insert

Before we go about trying to solve this problem... have you considered how many foul words you will spell out with such random codes?
--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 6, 2010 at 4:25 pm

#1176902
RE: First time manager - got book recommendations or tips?

Remember that the most successful managers are well informed and loyal leaders that set the example and are more like coaches than managers. Remember, also, that if you want...
--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 6, 2010 at 4:20 pm

#1176901
RE: Knowing What's Normal

Heh... when a patient comes in with a bone sticking out of the skin, guess what's wrong. 😉
I agree... too many people treat symptoms on SQL Server and, many times,...
--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 6, 2010 at 4:07 pm

#1176899
RE: Want to Calculate Business Working hours

Robert Goode (6/2/2010)
Hi Jeff,
Many thanks for posting this. If I could ask how I would go about modifying it to return the correct date and time based on an input...
--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 6, 2010 at 3:35 pm

#1176895
RE: Create date range with only one date using previous record's END DATE

timmynew11 (6/4/2010)
Sorry if I affended anybody, time constraints really stress people out. When stressed, some of the simpler problems tend to seem difficult. In case anybody is looking...
--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 6, 2010 at 3:20 pm

#1176894
RE: Collapsing a Table

lmu92 (6/6/2010)
Jeff, are you saying a c.u.r.s.o.r. should be preferred instead of the "double-row-number" approach??
In this case, yes because of the way the double row number problem needs to be...
--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 6, 2010 at 1:52 pm

#1176887
RE: Create date range with only one date using previous record's END DATE

timmynew11 (6/6/2010)
Actually the query works just fine on my 10,000 record table. The table won't be much bigger than it already is, so this solution works 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)

June 6, 2010 at 1:41 pm

#1176885
RE: Obtain the date of datetime field

sgtwilko (6/5/2010)
I found this an interesting discussion, particularly as this is something I've had to do a few times in the past.
We always try to keep the datetime as a...
--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 6, 2010 at 11:15 am

#1176870
RE: Collapsing a Table

cgreathouse (6/5/2010)
The limitation with this approach is you can't have more than 32,767 rows. But for my case this isn't an issue.
Heh... why do people insist on building "time...
--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 6, 2010 at 10:29 am

#1176865
RE: how can i do this convert

cfradenburg (4/6/2010)
Jeff, thanks for catching that. Any particular reason that you switched from charindex to patindex? Charindex can handle multiple characters and I'm assuming there's a reason 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 5, 2010 at 8:10 am

#1176791
RE: how can i do this convert

Bhuvnesh (4/6/2010)
Jeff Moden (4/5/2010)
Bhuvnesh,
I'm not taking a jab at you... I have to ask, though... how often do you find it necessary to split something longer than 8K bytes? ...
--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 5, 2010 at 7:57 am

#1176790
RE: Auto Increment Alphabet

Thanks for the feedback, Ankit...
There's a fair bit of complexity to using a base 26 "numbering" system like this even if you don't take into account all the swear words...
--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 5, 2010 at 7:21 am

#1176789
RE: Want to Calculate Business Working hours

Ken Champion (12/11/2009)
This is my first experience with a tally table. I modified your solution to calculate number of business days given the start datetime and end datetime, 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 4, 2010 at 9:44 pm

#1176776

Viewing 15 posts - 38,086 through 38,100 (of 59,098 total)