Jeff Moden

Forum Replies Created

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

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

Sergiy (1/17/2009)
Jeff Moden (1/17/2009)
If I were doing mortgage calculations, and let's assume that the max limit on the mortgage were, say, ummm... a penny less than a billion dollars... which...
--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 4:11 pm

#928781
RE: Select Where_Min()

Chad Crawford (1/16/2009)
Thanks RBarry, Matt, Ramesh and Jeff. This is good stuff, and exactly what I needed.
Chad
Thanks for the feedback, Chad.
--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:58 pm

#928779
RE: Select Where_Min()

RBarryYoung (1/16/2009)
I did test it Jeff. 🙂
And the execution plans are a reliable indication of what SQL Server is doing with a query as long as you remember what...
--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:55 pm

#928778
RE: Is there a Bug with the Replace() Function in SQL Server 2005

jim.riedemann (1/16/2009)
The length increase is not coming from REPLACE(), it's coming from the SELECT statement. If you run the following PRINT statement you will see that the output is only...
--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:33 pm

#928769
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

LeeBear35 (1/16/2009)
As like the solution using the Anchor value, I have not seen that "fix" before. I also wondered if the clustered index was generated with a fillfactor=100 is 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 3:28 pm

#928768
RE: SQL or Oracle

gints.plivna (1/17/2009)
Informix is dead, err I mean bought by IBM on 2001 😉
Heh.. a death knell for sure... anyone remember Lotus 123 or Symphony? And, if you actually like...
--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:20 pm

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

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