Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,146 through 41,160 (of 59,102 total)

RE: How do I extract numbers from a text field?

here's the optimizations I was talking about. There are two different types of optimizations... the first one is to reduce the number of concatenations and other calculations as 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)

November 15, 2009 at 7:16 am

#1079458
RE: How do I extract numbers from a text field?

... and the split function is just fine. I've tweeked it with some optimizations over time... I'll be right back to show 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)

November 14, 2009 at 4:45 pm

#1079426
RE: How do I extract numbers from a text field?

@jeff:
Well, I didn't post it for three reasons:
Heh... no worries, Lutz. It just struck me as odd because you normally cough up a whole solution. 🙂
--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 14, 2009 at 4:42 pm

#1079425
RE: How do I extract numbers from a text field?

Your welcome K... if you really want to learn how the Tally table works to replace WHILE Loops like Lutz did above, click on the TALLY table link in his...
--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 14, 2009 at 3:20 pm

#1079416
RE: Count(*)

Francis Yee-483501 (11/13/2009)
I learn from a site to get the row count of table(s) by NOT using count(*) but instead of using
" SELECT rows FROM sysindexes WHERE...
--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 14, 2009 at 1:53 pm

#1079405
RE: Exporting Data from SQL Server

Paul White (11/14/2009)
Jeff Moden (11/12/2009)
How would you do what the OP requested using SSIS? ie. Append it existing file if it exists or create a new file if 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 14, 2009 at 1:49 pm

#1079403
RE: Need help on varchar operation

Just another slant on this...
declare @yyyymm as varchar(6)
set @yyyymm='200901'
SELECT CONVERT(CHAR(6),CAST(@yyyymm+'01' AS DATETIME) -1,112) AS [Prev yyyymm],
CONVERT(CHAR(6),CAST(@yyyymm+'01' AS DATETIME)+32,112) AS [Next yyyymm]
My...
--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 14, 2009 at 1:26 pm

#1079398
RE: How do I extract numbers from a text field?

lmu92 (11/14/2009)
If you don't have a string split function yet, please search this side for it. There are several version available.
Heh... Lutz... why don't you just provide the 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)

November 14, 2009 at 1:01 pm

#1079390
RE: Date Conversion problem again

trudye10 (11/13/2009)
Hey Flo my apologies we all know ladies rule ;0)
Jeff, I appreciate the feedback it will be taken to heart. However I am low lady on the totem pole....
--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 13, 2009 at 4:19 pm

#1079301
RE: SQL Tuning where no PK exists

SQLNewbster (11/13/2009)
Umm, sorry. I didn't realize this was the SQL 2k forum. I just joined when I posted this. Many apologies for that.
NP... it's a common newbie...
--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 13, 2009 at 4:11 pm

#1079299
RE: SQL Tuning where no PK exists

GilaMonster (11/13/2009)
Jeff Moden (11/13/2009)
Gail, since this is 2k, do you think a partitioned view would help at all here? Or would it just muck things up?
Haven't worked much with...
--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 13, 2009 at 4:10 pm

#1079298
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Tom Garth (11/13/2009)
Jeff,
Terrific article. I haven't used Quirky Update for a few years, and that's a good thing because I didn't know all of the rules.
I don't want to stir...
--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 13, 2009 at 1:12 pm

#1079226
RE: How to stop developers from creating objects in master database

I've found that the real problem is that the default database for most logins is the MASTER database and the developers/user forget about that when they login. Change 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 13, 2009 at 11:37 am

#1079156
RE: problem with dll in clr project

A better question... what does the CLR actually do and why do you think you need a CLR to do 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 13, 2009 at 11:35 am

#1079154
RE: How to Prevent DBA's from viewing the data

lmu92 (11/13/2009)
Another option would be: get DBA's you trust.
The DBA job is mostly "underestimated" in terms of the requirements a person in such a position need to meet.
And one 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 13, 2009 at 11:33 am

#1079152

Viewing 15 posts - 41,146 through 41,160 (of 59,102 total)