Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,271 through 36,285 (of 59,067 total)

RE: Sequence-numbering groups

Paul White NZ (10/23/2010)
If the results need to be persisted, simply change the SELECT into a SELECT INTO.
Heh... Of course... I've really got to stop posting when I'm tired. ...
--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)

October 23, 2010 at 8:13 am

#1241280
RE: Sequence-numbering groups

Paul White NZ (10/23/2010)
I'm not sure I see where the requirement to update the original table comes from?
True enough. I suppose the output could be consumed by other 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)

October 23, 2010 at 8:02 am

#1241278
RE: SPLIT TSQL Between two character

With that good thought in mind, here's a link to all of Paul White's articles. For the current problem at hand, take a look at his two articles on...
--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)

October 22, 2010 at 10:37 pm

#1241237
RE: Sequence-numbering groups

Chris Morris-439714 (10/22/2010)
Heh Jeff's gonna hate me for this but I couldn't resist it.
400,000 rows in 15 seconds:
Actually, I don't hate you. That's some good, solid, creative, fast 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)

October 22, 2010 at 10:29 pm

#1241235
RE: SPLIT TSQL Between two character

Craig Farrell (10/22/2010)
WayneS (10/21/2010)
Here is the latest version of the Delimited Split Function
DelimitedSplit8k... d'oh. My bad. Thank you Wayne. It's now (finally) stored in my 'favorites' folder.
Jeff...
--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)

October 22, 2010 at 8:33 pm

#1241232
RE: SPLIT TSQL Between two character

By the way, if you do decide to use the DelimitedSplit8K function (which, of course, has lots of uses), here's how to solve the same problem using it... and 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)

October 22, 2010 at 8:22 pm

#1241231
RE: SPLIT TSQL Between two character

Craig Farrell (10/21/2010)
Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it, 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)

October 22, 2010 at 8:16 pm

#1241230
RE: SPLIT TSQL Between two character

Ok... we'll handle this in a couple of steps. First, we need some test data. Take a look at the first link in my signature line at 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)

October 22, 2010 at 4:27 pm

#1241216
RE: More efficient way

Bill_CCAC (10/22/2010)
It is fun Chad 😀
I'm thinking I shouldn't post the table structures or anything like that because of our privacy and security restrictions. I may have even stepped over...
--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)

October 22, 2010 at 1:48 pm

#1241163
RE: SPLIT TSQL Between two character

ja0 (10/22/2010)
I made simple function that make what I wanted. The problem is that, I dont know how to do with a table like this,
ID Value
1 ...
--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)

October 22, 2010 at 1:46 pm

#1241161
RE: replacing long running cursor

Ah... my apologies. I didn't look to see that this is for an SQL Server 2000 instance.
Unless WayneS or someone else beats me to it (which I don't mind...
--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)

October 22, 2010 at 7:15 am

#1240884
RE: replacing long running cursor

Sanjay-940444 (10/20/2010)
I have one question here
Does SQL Server guarantee that update will be done strictly in top down manner?
I didnt find it writtem anywhere in BOL.
Actually, like anything else, 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)

October 22, 2010 at 7:03 am

#1240881
RE: fn_getfiledetails - a replacement for xp_getfiledetails

SQLKnight (6/17/2010)
I agree with the SSC Rookie's post. sp_OAGetProperty is very soon to get deprecated. We shall replace such codes with CLR functions.
Thanks for the article though.
Heh... Microsoft continues 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)

October 22, 2010 at 6:54 am

#1240872
RE: which cmd or function can transfer printed message to a sql file?

lvzheng (10/22/2010)
then how can i get them from Windows Event Viewer?
xp_readerrorlog. See the following article for a bit more information...
http://www.sqlteam.com/article/using-xp_readerrorlog-in-sql-server-2005
BUT, now that you've said that, WHY do you feel...
--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)

October 22, 2010 at 6:50 am

#1240868
RE: SPLIT TSQL Between two character

WayneS (10/21/2010)
Craig Farrell (10/21/2010)
Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on 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)

October 21, 2010 at 11:35 pm

#1240721

Viewing 15 posts - 36,271 through 36,285 (of 59,067 total)