Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,106 through 30,120 (of 59,101 total)

RE: EXECuting a dynamic string

None of what you seek to do actually requires any form of dynamic SQL from what I can see.
--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)

May 10, 2012 at 5:58 pm

#1486048
RE: triggers? oh no..

Many accounting packages force changes to LastModifiedOn and LastModifiedBy columns using triggers as well as using them for auditing. They will also sometimes have triggers that reject any changes...
--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)

May 10, 2012 at 5:56 pm

#1486047
RE: Finding rows with wildcards in the string and rows with spaces in front or at the end of the string.

cadm777 (5/10/2012)
Jeff,
I was looking that up. Then I saw your post. I read the article you suggested on "ISNUMERIC" It was very...
--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)

May 10, 2012 at 5:46 pm

#1486045
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Very cool. Thanks for the success story, Robin. Glad it helped.
--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)

May 10, 2012 at 5:41 pm

#1486044
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

Ugh, Nope. Couple ah chickens though.
--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)

May 10, 2012 at 5:38 pm

#1486043
RE: query works but not in a view

PaulB-TheOneAndOnly (5/10/2012)
Jeff Moden (5/9/2012)
PaulB-TheOneAndOnly (5/9/2012)
If MSTR_END on WHERE clause is causing the issue replace the condition with:
where TO_CHAR(MSTR_END,"DD-MON-YYYY") = ''01-JAN-1700''
IIRC, that'll make for a non-SARGable search predicate just like in...
--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)

May 10, 2012 at 5:36 pm

#1486042
RE: Performance Test of New Date Manipulation Functions (SQL Spackle)

As usual, awesome article, Wayne.
It is a bit amazing to me that MS isn't, for some reason, able to do performance wise at the base code level what we're able...
--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)

May 10, 2012 at 8:31 am

#1485736
RE: Formatting Dates with 3 Character Months (SQL Spackle)

Wow! I just read Paul's article. He really does do a nice job explaining some of these things.
To summarize, TOP apparently doesn't fix things for 2008...
--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)

May 10, 2012 at 8:04 am

#1485721
RE: Formatting Dates with 3 Character Months (SQL Spackle)

peter-757102 (5/10/2012)
Jeff Moden (5/10/2012)
I did miss that. Thank you for the update.
Looking back in this thread and switching gears a bit, the new improved splitter article did come out....
--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)

May 10, 2012 at 7:51 am

#1485712
RE: Looking for the inverse of xp_fixeddrives

Paul Els (3/3/2012)
I see you guys are adament that I must start a new post for the same topic. I find it interesting that we are in 2012 and from...
--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)

May 10, 2012 at 7:46 am

#1485708
RE: Selecting from hierarchies like Managers and Employees

Kristian Ask (5/10/2012)
Jeff,
Great reading!
I was reading the entire post just waiting for your test.... good thing you already did it once. Personally I've been replacing quite a few rCTEs because...
--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)

May 10, 2012 at 7:42 am

#1485704
RE: Formatting Dates with 3 Character Months (SQL Spackle)

I did miss that. Thank you for the update.
Looking back in this thread and switching gears a bit, the new improved splitter article did come out. An hour...
--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)

May 10, 2012 at 7:18 am

#1485680
RE: String conversion

ChrisM@Work (5/10/2012)
SELECT STUFF(REPLACE('/'+CONVERT(VARCHAR(10),GETDATE(),1),'/0','/'),1,1,'')
That's what my original code looked like. The problem is that it knocks out the leading 0 on 2 digit years when they happen. Now, if...
--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)

May 10, 2012 at 6:58 am

#1485668
RE: Are the posted questions getting worse?

Koen Verbeeck (5/9/2012)
GilaMonster (5/9/2012)
Koen Verbeeck (5/9/2012)
Is this an Oracle thing?
No, don't touch that myself.
Normally I don't either, but someone has to convert all that PL/SQL to T-SQL...
Neh... get 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)

May 10, 2012 at 12:49 am

#1485485
RE: Are the posted questions getting worse?

Lynn Pettis (5/9/2012)
Jeff Moden (5/9/2012)
Lynn Pettis (5/9/2012)
Sorry for the code, but I need a place to keep these solutions for a hypothetical problem on another thread.
Wow! Working with Oracle...
--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)

May 10, 2012 at 12:46 am

#1485484

Viewing 15 posts - 30,106 through 30,120 (of 59,101 total)