Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,806 through 38,820 (of 59,072 total)

RE: Are the posted questions getting worse?

anthony_merriwether (4/19/2010)
If the truth be known, I too agree that a person should strive to solve a problem no matter what it is, by due diligence and at the very...
--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)

April 19, 2010 at 10:38 pm

#1154286
RE: Previewing data in cross tab format

Thanks for the feedback, Andy.
--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)

April 19, 2010 at 10:29 pm

#1154282
RE: MCJ - The Missing Link

Good. Because of my inherent distrust in all the other certifications, I'd like to see this one materialize provided that less fortunate folks can actually afford to attain it....
--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)

April 19, 2010 at 10:27 pm

#1154280
RE: Pivoting name value pairs

Heh... I always get left holding the test bag... starting to feel like a cleaning lady. 😛
Like I said, the Execution Plan lies. You should never rely on it...
--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)

April 19, 2010 at 9:59 pm

#1154264
RE: Are the posted questions getting worse?

anthony_merriwether (4/19/2010)
This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of...
--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)

April 19, 2010 at 8:44 pm

#1154256
RE: Are the posted questions getting worse?

Gianluca Sartori (4/19/2010)
Jeff Moden (4/16/2010)
Heh.... famous last words would be... [font="Arial Black"]AHHHHH CRAP![/font]
Just so you guys know... remember I said that I changed my cteTally code to use Gianluca's wonderful...
--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)

April 19, 2010 at 8:39 pm

#1154255
RE: Previewing data in cross tab format

You can't use the aggregate inside the CASE for this. Something like the following would work...
SELECT stMedium,
SUM(CASE WHEN nYear...
--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)

April 19, 2010 at 8:21 pm

#1154251
RE: Overactive use of Temp Tables?

I agree. Thanks, Bob!
--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)

April 19, 2010 at 7:34 pm

#1154240
RE: MCJ - The Missing Link

It's been a week since the last reply. You guys didn't give up on the idea did 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)

April 19, 2010 at 7:29 pm

#1154238
RE: dateDiff question

SQL_NuB (4/19/2010)
that is setup for the start date or end date begin on a weekend, I need to find out if the day between my two dates are a saturday...
--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)

April 19, 2010 at 7:21 pm

#1154233
RE: Are the posted questions getting worse?

lmu92 (4/19/2010)
Steve Jones - Editor (4/19/2010)
I added some levels to the count. Didn't announce it since they really only applied to me for now. Jeff/Lynn/Gal soon.
"Soon" has been recently?
See here...
--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)

April 19, 2010 at 6:56 pm

#1154222
RE: Why doesn't this work?

Heh... you know what they call people who try to "roll their own" when it comes to encryption? Hacked and unemployed.
Don't try to write your own encryption...
--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)

April 19, 2010 at 3:26 pm

#1154177
RE: Some problem for Stored Procedure

only4mithunc (4/19/2010)
Thanks for the reply.
Unfortunately I didn't check these two things... And as I mentioned, when I dropped and recreated the SP it was fine, so no chance to replicate...
--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)

April 19, 2010 at 3:22 pm

#1154174
RE: Renaming Tables

Using sp_Rename takes less than 65 milliseconds to execute even on the slowest of boxes and it's usually a whole lot faster than that. Are you sure that it's...
--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)

April 19, 2010 at 3:01 pm

#1154170
RE: Previewing data in cross tab format

Oddly enough, I agree. 😉 A dynamic Cross Tab would be the way to go and the two articles Lutz cited will teach you how to do that 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)

April 19, 2010 at 2:55 pm

#1154166

Viewing 15 posts - 38,806 through 38,820 (of 59,072 total)