Jeff Moden

Forum Replies Created

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

RE: Timestamp to Datetime

javid.alimohideen (4/6/2009)
True,
I completely agree with you that it is a bug. I was just looking for a quick workaround to keep the process going until I fix it 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)

April 7, 2009 at 11:12 am

#973637
RE: Timestamp to Datetime

Heh... actually, I love it being there... I'm currently working as a consultant and gives me more to fix. 😀
--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 11:11 am

#973634
RE: The T-SQL Paradigm

wldhrs (4/6/2009)
Jeff Moden (4/6/2009)
Heh... brackets... they sure did take a shortcut there. It would be nice if the automatic code generators didn't put those in unless actually required.
I disagree...
--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 11:09 am

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

Gift Peddie (4/7/2009)
Personally, I don't care if you're black, white, yellow, red, brown, purple, male, female, something in between, have 3 eyes, or glow in the dark... if 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 11:02 am

#973621
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

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