Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,906 through 40,920 (of 59,069 total)

RE: Creating a union using multiple tables

mister.magoo (11/26/2009)
...wanted to offer an alternative that requires no user input beyond the initial running of the script....(I like not having to think)
How did the ol' Magoo cartoons always end?...
--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)

November 29, 2009 at 7:11 pm

#1085213
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

I'm glad to see a kindred spirit out there, Noel. Thanks for the cheer-me-up. Your post is a big breath of fresh air. Thank you, Sir. 🙂
--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)

November 29, 2009 at 6:49 pm

#1085211
RE: REPLACE Multiple Spaces with One

Paul White (11/29/2009)
C# Screw (11/29/2009)
Oh but if I switch current database from Master to 'Another' database I get very differerent results...
The collation thing again. It'd probably be fairer to...
--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)

November 29, 2009 at 6:05 pm

#1085210
RE: REPLACE Multiple Spaces with One

The collation and sort order would certainly explain the performance differences. All of mine (including Master and TempDB) are setup using the installation default of SQL_Latin1_General_CP1_CI_AS. You might...
--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)

November 29, 2009 at 5:40 pm

#1085206
RE: REPLACE Multiple Spaces with One

C# Screw (11/29/2009)
Oh but if I switch current database from Master to 'Another' database I get very differerent results:
Ah ha... I wonder how many other folks have the default DB...
--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)

November 29, 2009 at 11:14 am

#1085150
RE: REPLACE Multiple Spaces with One

C# Screw (11/27/2009)
Must be some hardware having influence on this, or is this being affected by collation..
Pro Duo, 2gb ram, 700MB free, SQL 2005
Looks like I didn't lose the code...
--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)

November 29, 2009 at 11:08 am

#1085149
RE: REPLACE Multiple Spaces with One

C# Screw (11/25/2009)
Hello Jeff
would you think the HasSpace is finally getting rid of the RBAR? - I am thinking this because this is the only solution where SQL can use...
--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)

November 28, 2009 at 11:51 am

#1085102
RE: REPLACE Multiple Spaces with One

It has been fun to say the least, Barry. And, I'll always refer to you whenever I hear the term "Pseudo-Cursor" because you're the first one I heard 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)

November 28, 2009 at 11:37 am

#1085101
RE: Parse strings to get select output

I can't get it to fail with any of the data you've provided. Then only thing that I can think of is...
1) Maybe you're providing the wrong line of...
--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)

November 28, 2009 at 11:34 am

#1085100
RE: cursor...data reporting

xponcall (11/27/2009)
Hi Jeff,
The reason for this report and data present this way are for account department audit analysis, which have keep the track of the inventory flow in and...
--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)

November 28, 2009 at 11:29 am

#1085099
RE: cursor...data reporting

You miss the point I was trying to make... why do you have both an input and an output ProdID and Qty? What are the rules for what goes...
--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)

November 27, 2009 at 12:17 pm

#1085004
RE: Table Update Help Needed

Actually, the rewrite is out there now...
--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)

November 27, 2009 at 12:09 pm

#1085002
RE: REPLACE Multiple Spaces with One

Mitesh Oswal (11/26/2009)
please check this ,
DECLARE @srtWord VARCHAR(8000)
SELECT
@srtWord = '1'+SPACE(7998)+'2'
select @srtWord
select @srtWord = REPLACE(REPLACE(REPLACE(CAST(@srtWord AS VARCHAR(MAX)),' ','$#$'),'$$#',''),'$#$',' ')
select @srtWord
Yes,...
--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)

November 27, 2009 at 10:39 am

#1084986
RE: Parse strings to get select output

It would be a help if you could post the data that caused the problem. 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)

November 27, 2009 at 9:44 am

#1084966
RE: cursor...data reporting

Including the test data creation, there are 250 lines of undocumented code there... would you care to explain the rules of what it does?
--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)

November 26, 2009 at 8:09 pm

#1084754

Viewing 15 posts - 40,906 through 40,920 (of 59,069 total)