Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,031 through 42,045 (of 59,102 total)

RE: Currency Format

Ah dang... thanks for the feedback, Yumi. I've gotta remember to read the name of the forum I'm trying to answer the question on. I was thinking pure...
--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)

September 9, 2009 at 8:04 pm

#1051524
RE: Are the posted questions getting worse?

Grant Fritchey (9/9/2009)
WHOOP!
I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
:blush: Heh... that's odd. I was going to say...
--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)

September 9, 2009 at 7:53 pm

#1051521
RE: Performance issue with tally solution

Eggsactly...
--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)

September 9, 2009 at 1:06 pm

#1051376
RE: Using the Best

Actually, we've gotten a bit off track. I don't mind people asking questions on forums... in fact, I recommend it because there are so many great folks out 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)

September 9, 2009 at 1:02 pm

#1051372
RE: Am I the only DBA

Shall we know the real name of such a hard working individual that spends time rearranging people's last names to be offensive words? I did initially try to make...
--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)

September 9, 2009 at 9:45 am

#1051240
RE: Am I the only DBA

Perhaps you should also 😉
--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)

September 9, 2009 at 9:01 am

#1051197
RE: Performance issue with tally solution

budi.bong (9/9/2009)
How can I perform SQL SELECT FROM or given a SqlXml object?
Just a suggestion to get the right kind of help... rather than posting this on a thread having...
--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)

September 9, 2009 at 8:52 am

#1051184
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Heh... oh, be careful, David. While it's true that sometimes the "Squeaky wheel gets the grease", it's also true that sometimes the "Squeaky wheel gets greased" if you understand...
--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)

September 9, 2009 at 8:41 am

#1051171
RE: Using the Best

jonathan allen (9/8/2009)
Buck Woody's blog is quoted as saying 'the best' depends on circumstances. Some of us are in that predicament when it comes to training, knowledge, time and resources.
Thanks...
--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)

September 9, 2009 at 1:31 am

#1050938
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Heh... of course, the proper way to fix this would be to correctly normalize the data with a separate company name column. But, I suspect that's not currently an...
--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)

September 9, 2009 at 1:05 am

#1050925
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

David Lester (9/8/2009)
Thanks, I had also reached the conclusion I would have to have a way to know the entry was a person vs not a person. It occured...
--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)

September 9, 2009 at 1:03 am

#1050923
RE: ANYTHING THAT CAN HELP TRIM THE DATA FOR A GIVEN STRING...

Jack Corbett (9/8/2009)
Darn it Jeff, I know I have seen that solution somewhere before, don't know if it was by you or not, but I wish I would have remembered...
--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)

September 9, 2009 at 12:44 am

#1050917
RE: Deadlocking while running constant inserts/updates against tables

Clint (9/8/2009)
However, the stored procedure that moves them from the staging to the main tables is always the point of deadlock.
Post that code right away...
--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)

September 9, 2009 at 12:30 am

#1050909
RE: Can I use a cursor Inside of a Function

Oh my, no....
You don't need the slothfulness nor resource usage of a cursor here. I don't have access to an SQL Server this week but consider the following code...
DECLARE...
--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)

September 9, 2009 at 12:17 am

#1050908
RE: equivalent for rownum

PaulB (9/8/2009)
newbieuser (9/8/2009)
I do 'select rownum from table' in oracle to select rows ordered by rownum.
:w00t: No, you don't.
In the Oracle world rownum is a pseudo-column, Oracle assigns -to rownum-...
--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)

September 8, 2009 at 11:48 pm

#1050906

Viewing 15 posts - 42,031 through 42,045 (of 59,102 total)