Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,826 through 45,840 (of 59,095 total)

RE: SQL Bulk Insert

Sorry... I asked the wrong question... does the target table have any data in it that you actually want to keep? If it does, then you can't get true...
--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 17, 2009 at 3:08 pm

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

GilaMonster (1/17/2009)
Jeff Moden (1/17/2009)
the thing is that Ranking can take care of that one because you're grouping by day.
No, I'm not. A group is any number of events that...
--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 17, 2009 at 3:06 pm

#928760
RE: Phone Numbers Table Design

Not if you want to include anything outside of the U.S.A, Canada, or either of their NANPA territories.
The country code for [font="Arial Black"]any [/font]telephone number that has an NPA/NXX (Area...
--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 17, 2009 at 3:00 pm

#928758
RE: Hidden RBAR: Triangular Joins

Joe Celko (1/17/2009)
If SQL Server was up to ANSI/ISO Standards, we would have POSIX style regular expression in the SIMILAR TO predicate, like other SQLs. This is one...
--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 17, 2009 at 2:52 pm

#928757
RE: Hidden RBAR: Triangular Joins

I understand what you're trying to say, my dear ol' and trusted friend... but there is no time in the past nor anytime in the future where I have or...
--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 17, 2009 at 2:46 pm

#928756
RE: Are the posted questions getting worse?

GSquared (1/16/2009)
I doubt whatever server SSC is using could hold a complete list of everyone who has ever deserved one of Jeff's porkchops! There just plain isn't that much...
--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 17, 2009 at 2:02 pm

#928747
RE: Are the posted questions getting worse?

GilaMonster (1/17/2009)
You're not the only one. I did so earlier in the week in a comment about a correlated subquery.
The difference is that it's not common and we correct 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)

January 17, 2009 at 2:01 pm

#928746
RE: Are the posted questions getting worse?

Grant Fritchey (1/17/2009)
Ninja's_RGR'us (1/17/2009)
So what?, only 2 people on that thread answered without reading (or understanding) the question.
Since when reading the full question a requirement of posting an answer?
😀
Maybe 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)

January 17, 2009 at 1:54 pm

#928742
RE: Are the posted questions getting worse?

GilaMonster (1/17/2009)
Not a bad question, but does this guy ever read the posts that he's answering?
http://www.sqlservercentral.com/Forums/FindPost638650.aspx
Question was "I didn't start an explicit transaction, I don't have a backup, how do...
--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 17, 2009 at 1:51 pm

#928740
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

jon.skin (1/17/2009)
The examples of crosstabbing given are very good by only work with numeric crosscasting.
If you try a similar method with textual columns you cannot use GROUP BY because 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 17, 2009 at 1:36 pm

#928736
RE: Calculate pmt in t-sql (like excel)

Don't, even for a second, think that I'm trying to fan any flames here. 🙂 I'm only interested in knowing because you guys have probably forgotten more 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 17, 2009 at 1:32 pm

#928734
RE: Timesheets for DBA/DBDs

Michael Meierruth (1/17/2009)
Jeff, I'm glad being in the category of consultants has proved to be positive for your situation.
Me too and I'm very happy it wasn't me that got 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)

January 17, 2009 at 1:14 pm

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

GilaMonster (1/17/2009)
I've got a similar one that I'm working on, that does have a legit business requirement. I don't need a solution, I did figure one out after staring at...
--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 17, 2009 at 1:11 pm

#928727
RE: Hidden RBAR: Triangular Joins

I've checked in your recent posts on this thread and I'm not seeing a link that you posted. I'm probably just missing it... would you do me the favor...
--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 17, 2009 at 1:04 pm

#928725
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
Did you actually read the link I sent - fully, including the link at the top to the original article (which I explicitly called out in my post)?? ...
--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 17, 2009 at 12:58 pm

#928724

Viewing 15 posts - 45,826 through 45,840 (of 59,095 total)