Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,706 through 42,720 (of 59,067 total)

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

Paul White (7/26/2009)
Still, $799 looks better as US$524 - is that expensive? I honestly don't know.
It's more than a week's pay for a lot of folks. I know...
--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:30 am

#1030253
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.

RBarryYoung (7/10/2009)
arthykannan (7/6/2009)
You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email doesnt...
--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:19 am

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

I almost forgot... yes, I'm using IE.
--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:15 am

#1030249
RE: differiniate quotes as data vs quotes as column identifier
Ok... here's a full up working example with the data you provided. As always, the detail is in the comments in the code...
```
--===========================================================================================================
--      We...
```
--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 12:37 am

#1030248
RE: differiniate quotes as data vs quotes as column identifier

Ummmm.... "Weekend".... new word for me... guess I'll have to look it up. 😛
Since you know how to do the BULK INSERT, we'll start with a staging table... I'll 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)

July 25, 2009 at 11:21 pm

#1030245

Viewing 15 posts - 42,706 through 42,720 (of 59,067 total)