Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,311 through 44,325 (of 59,097 total)

RE: Just Walk Away - Blacklisting - and Twits without Twitter

Bob Hovious (4/7/2009)
Thanks, Jeff. I was feeling the same frustration I used to feel in arguments with my first wife when she would tell me what my...
--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 7, 2009 at 10:56 am

#973616
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Jeff Moden (4/7/2009)
Bob Hovious (4/7/2009)
But could someone please point me to the language where I suggested that there should be an official blacklist?
Specifically, you didn't. Grant mentioned it first...
--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 7, 2009 at 10:54 am

#973614
RE: Challenging SQL interview questions

The 2nd question has nothing to do with SQL, either. It's about a "tabular file".
--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 7, 2009 at 10:30 am

#973595
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Bob Hovious (4/7/2009)
But could someone please point me to the language where I suggested that there should be an official blacklist?
Specifically, you didn't. Grant mentioned it first and 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)

April 7, 2009 at 10:24 am

#973592
RE: Just Walk Away - Blacklisting - and Twits without Twitter

GilaMonster (4/7/2009)
Jeff Moden (4/7/2009)
But then I saw it happen today. One of us made just the smallest snyde remark about helping someone on what was obviously a laundry...
--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 7, 2009 at 10:01 am

#973570
RE: Just Walk Away - Blacklisting - and Twits without Twitter

Gift Peddie (4/7/2009)
I've been thinking about this a bit. I think that those that want to help and post should reserve their own judgment. They should have the chance to...
--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 7, 2009 at 9:59 am

#973566
RE: Are the posted questions getting worse?

Roy Ernest (4/7/2009)
Lynn Pettis (4/6/2009)
Roy Ernest (4/6/2009)
And it is no surprise that Lynn is dealing very patiently. He is THE SAINT.. 🙂
Next I want to see Lynn being nominated as...
--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 7, 2009 at 9:42 am

#973535
RE: Are the posted questions getting worse?

Lynn Pettis (4/6/2009)
Well, we just got a call tonight, my wife's aunt died today. Apparently there won't be a funeral, so not sure what is going on there. ...
--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 7, 2009 at 9:37 am

#973526
RE: Duplicate Records using SQLCMD

Renato Buda (4/7/2009)
Jeff Moden's comment is an interesting one. Jeff must have the pleasure of always working with well designed databases.:-P.
Alas... if that were only true. I'm 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)

April 7, 2009 at 9:31 am

#973515
RE: Manners

Heh... the way I diffuse it at work is I tell the offender to go to his/her "corner" and come back when they calm down. Hasn't failed yet. ...
--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 7, 2009 at 9:27 am

#973509
RE: How to display number of rows in each table in database

Perhaps a bit more information as well as the rowcount would help... and, yes, I used deprecated views so that it's backwards compatible with 2k...
[font="Courier New"]/**********************************************************************************************************************
Purpose:
Returns a single...
--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 7, 2009 at 1:39 am

#973144
RE: Need T-SQL to list tables by Parent, Dependent, Descendent, etc

DBASkippack (4/6/2009)
Looking for T-SQLto list my tables in a single database in hierarchical fashion.. with all PARENT tables 1st, followed by all dependants, then all descendants, etc..
eg.
Corporation_Table
Branch_Table
...
--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 7, 2009 at 1:28 am

#973139
RE: Just Walk Away - Blacklisting - and Twits without Twitter

I've seen lots and lots of folks agreeing that some of the greatest abusers on this forum are merely understood or just having a frustrating moment, etc, etc. But...
--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 7, 2009 at 1:25 am

#973137
RE: Calculate To Date

Do an update where the base currency and local currency match on a self join on the table. The row to update would be the max FromDate less than...
--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 7, 2009 at 1:04 am

#973132
RE: Just Walk Away - Blacklisting - and Twits without Twitter

I don't believe an "official" blacklist is ever necessary. It doesn't take long to figure out whether or not someone is going to launch on you. You can...
--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 7, 2009 at 1:01 am

#973130

Viewing 15 posts - 44,311 through 44,325 (of 59,097 total)