Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,736 through 42,750 (of 59,102 total)

RE: Heh... I broke it.

Mel Harbour (7/28/2009)
Jeff,
Don't worry - I do understand the slightly larger problem, and we're looking into what we can do to fix it in general, or find a nice compromise...
--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)

July 28, 2009 at 10:46 am

#1031171
RE: Are the posted questions getting worse?

Grant Fritchey (7/28/2009)
Jeff Moden (7/27/2009)
Grant Fritchey (7/27/2009)
Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the hardest 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)

July 28, 2009 at 8:58 am

#1031082
RE: Heh... I broke it.

Mel Harbour (7/28/2009)
Hi,
I've edited the post to temporarily fix it, without deleting it. Essentially, if you want 'simple' blocks, with no code formatting, rather than surrounding your code with 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)

July 28, 2009 at 6:28 am

#1030977
RE: Are the posted questions getting worse?

Lynn Pettis (7/27/2009)
Well, it is now official. We are down one daughter in our household.
Kassondra is now on her way to Fort Jackson in South Carolina to start her...
--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)

July 27, 2009 at 8:48 pm

#1030819
RE: Are the posted questions getting worse?

Grant Fritchey (7/27/2009)
Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the hardest time getting anyone, from 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)

July 27, 2009 at 8:39 pm

#1030818
RE: Intersect, Except, Union, All and Any

Stephen Worthington (7/27/2009)
Interesting article, but I don't think your examples really capture what the functionality was intended to provide.
They are set operations (nicely illustrated in your Venn diagrams at...
--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)

July 27, 2009 at 8:30 pm

#1030815
RE: Intersect, Except, Union, All and Any

phickey (7/27/2009)
EXCEPT and INTERSECT are especially useful for comparing multiple columns of data where (a) there is no primary key or (b) having the same primary key does not guarantee...
--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)

July 27, 2009 at 9:29 am

#1030601
RE: You guys suck. every time we have to go and register or it says we have to go and click the f**king link. and the email doesnt get send immediately.

Steve Jones - Editor (7/27/2009)
I saw this in my notifications, thinking, great, another fun complaint for Monday.
And apparently you folks are getting ready for lunch. Enjoy!
Heh... not to worry... old...
--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)

July 27, 2009 at 9:13 am

#1030590
RE: Problem with Query

You bet, Chandra... thanks for the feedback.
--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)

July 27, 2009 at 6:05 am

#1030444
RE: How to Disable SP_Helptext

Peso (7/26/2009)
Or create the procedures and functions using
WITH ENCRYPTION
will make it harder for people to read your code.
Heh... just make sure that you have clear copy of the code stashed...
--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)

July 26, 2009 at 3:03 pm

#1030324
RE: dynamic sql in 2005

That would certainly do it. Just watch for problems on that if the old database was 80 compatible...
--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)

July 26, 2009 at 3:01 pm

#1030323
RE: Want to Calculate Business Working hours

Thought I'd in throw an update to this problem...
If I may suggest...
1. We don't need RBAR to do this... no WHILE loops please. :sick:
2. We don't need 8 functions...
--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)

July 26, 2009 at 2:04 pm

#1030310
RE: Calculating the Number of Business Hours Passed Since a Point of Tme

If I may suggest...
1. We don't need RBAR to do this... no WHILE loops please. :sick:
2. We don't need 8 functions to do this... that's a lot of complicated...
--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)

July 26, 2009 at 1:14 pm

#1030303
RE: Heh... I broke it.

Lowell (7/26/2009)
yeah i saw that...IE spins forever. tried with firefox, and after a couple of "do you want to stop the runaway script" warnings, it would finally open. ...
--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)

July 26, 2009 at 10:36 am

#1030290
RE: Some forum issues fixed

Mel,
I broke it... any chance of you taking a look at the following, please. Yeah, it's the code window again but I broke it bad enough to make...
--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)

July 26, 2009 at 9:54 am

#1030287

Viewing 15 posts - 42,736 through 42,750 (of 59,102 total)