Jeff Moden

Forum Replies Created

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

RE: Question whit bulk copy

I believe the file name needs to be in quotes, folks.
--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 6:11 pm

#929431
RE: Disable and enable trigger

Yes... there is. Please see "Enable Trigger" and "Disable Trigger" in Books Online.
Also, I'd be very, very wary of doing such a thing. The tirgger(s) were put on...
--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 6:09 pm

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

john.arnott (1/19/2009)
I've had to present a "best guess" at matching events from two data sources. Each source provides a subject identifier that tells where a package came from, 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)

January 19, 2009 at 5:58 pm

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

Jacob Luebbers (1/19/2009)
Hey Jeff,
Not sure if you're including "running sum" or similar problems in your question...? If so, a common reason for needing that in my experience...
--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 5:52 pm

#929428
RE: Are the posted questions getting worse?

Jack Corbett (1/19/2009)
K. Brian Kelley (1/19/2009)
GilaMonster (1/19/2009)
Jack Corbett (1/19/2009)
That's probably my favorite feature of the google toolbar, spell checking just like in Word.
Firefox has that built in. Why do 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 5:00 pm

#929423
RE: Are the posted questions getting worse?

GilaMonster (1/19/2009)
🙂 and I'm in the middle of writing a blog rant titled "Bad Advice". It's funny when lots of people write on similar topics at once.
Maybe not so funny......
--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:58 pm

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

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