Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,116 through 41,130 (of 59,069 total)

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
RE: SQL Tuning where no PK exists

Gail, since this is 2k, do you think a partitioned view would help at all here? Or would it just muck things up?
--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:26 am

#1079144
RE: Consolidating Again and Again and Again

Still, mirroring, log shipping, or what have you to a server a couple of hundred miles away will save your company's hiney if your building is flooded, get's hit by...
--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:18 am

#1079136
RE: row as column

sudarsanan.kaliyamurthy (11/13/2009)
I have attached the sample data and the required table.
You'll be amazed at how quickly you'll get an answer if you study the link that Lutz directed you 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 13, 2009 at 11:09 am

#1079129

Viewing 15 posts - 41,116 through 41,130 (of 59,069 total)