Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,781 through 45,795 (of 59,095 total)

RE: Are the posted questions getting worse?

RBarryYoung (1/19/2009)
I'll take a look at it if you want, Jeff. Just to see how much of it is about me. 😀
"You have mail". 😛
--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)

January 19, 2009 at 4:56 pm

#929421
RE: Are the posted questions getting worse?

Jeff Moden (1/19/2009)
Bob Hovious (1/19/2009)
I keep biohazard emblems for all occasions. Sort of like online mood rings. You too can compile your own library if 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)

January 19, 2009 at 3:39 pm

#929411
RE: Are the posted questions getting worse?

Bob Hovious (1/19/2009)
I keep biohazard emblems for all occasions. Sort of like online mood rings. You too can compile your own library if you just search...
--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)

January 19, 2009 at 3:21 pm

#929404
RE: Are the posted questions getting worse?

Bob Hovious (1/19/2009)
Hey Jeff: Would you consider distributing it privately?
Sure... right after you tell me where you got that awesome rendition of the bio-hazard icon. 😛 I'd...
--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)

January 19, 2009 at 2:56 pm

#929395
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/19/2009)
Sorry Jeff, but you are completely disconnected from reality on this topic. And since I have tried umpteen times to get you to realize that I won't bother...
--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)

January 19, 2009 at 2:49 pm

#929393
RE: Are the posted questions getting worse?

Jack Corbett (1/19/2009)
Here's a good blog post about people just implementing solutions form the internet or forums without caring why:
http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html
I found this on a tweet by Jonathan Kehayias.
How odd... I...
--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)

January 19, 2009 at 2:27 pm

#929383
RE: Opening & Closing Stock Problem

Better than all of that, let's see what YOU have tried. We're not consultants that work for free to write other people's code... we're here to help you with...
--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)

January 19, 2009 at 2:17 pm

#929379
RE: Phone Numbers Table Design

I keep trying to walk people into a more generic solution but I keep seeing the word "NPA" as a column name. This is something like what I'm trying...
--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)

January 19, 2009 at 1:58 pm

#929373
RE: Need output as 1,2,3,...10

I guess that's what I'm getting at, folks. My answer to such a question in an interview would be to first answer the question correctly as many of 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)

January 19, 2009 at 1:35 pm

#929363
RE: Hidden RBAR: Triangular Joins

Charles Kincaid (1/19/2009)
Sorry, Jeff. I was not clear enough. My contention is that a C# CLR proc and a VB CLR proc would run the same as each...
--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)

January 19, 2009 at 1:14 pm

#929358
RE: Surface Possibilities

Steve Jones - Editor (1/18/2009)
I hadn't thought about the repetitive motion thing. I guess long term it could be, but for presentations, they're an hour or two. I wish I...
--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)

January 19, 2009 at 11:23 am

#929330
RE: Why do people need to do this?

Ramesh (1/18/2009)
I would like to share my thoughts on the need of such rules.
I have the punch/swipe card data imported from some other system in the following format...
EmployeeNo, CardReaderNo, CardReaderType,...
--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)

January 19, 2009 at 10:57 am

#929323
RE: Hidden RBAR: Triangular Joins

Charles Kincaid (1/19/2009)
Given competent coders on both sides C# vs VB races based on execution speeds mostly end in dead heats.
Hi Charles... thanks for joining in. Just curious about...
--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)

January 19, 2009 at 10:50 am

#929321
RE: Need output as 1,2,3,...10

... and, still, in an interview, none of the solutions are the correct answer.
Other than a firedrill on this forum, when have any of you actually had to concatenate data...
--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)

January 18, 2009 at 10:11 pm

#929018
RE: Selecting from temp table outside SP?

ALZDBA (1/18/2009)
1) create your temp tables up front in stead of using select into.
What is the advantage?
--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)

January 18, 2009 at 10:05 pm

#929017

Viewing 15 posts - 45,781 through 45,795 (of 59,095 total)