Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,066 through 43,080 (of 59,063 total)

RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

wesigler (7/6/2009)
My approach is to come up with a couple of options and then look at the pros and cons of each.
Then, my approach would be to avoid all deadlocks...
--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)

July 6, 2009 at 7:34 pm

#1020803
RE: SQL Split query

sanjeev40084 (7/6/2009)
see if this works:
http://sqlservercode.blogspot.com/2005/09/split-comma-delimited-string-fast.html
Heh... that blog contains the same method we've already talked about in this thread.... except it's usually just called a "Numbers" or "Tally" table instead 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)

July 6, 2009 at 3:12 pm

#1020689
RE: CHARINDEX in reverse

Sergiy (7/5/2009)
Jeff Moden (7/2/2009) Andrew already did exactly what I would do...
I would not.
There was a member of Led Zeppelin, John Paul Jones.
Would not be happy seeing his name...
--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)

July 6, 2009 at 2:54 pm

#1020668
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

I'm still wondering about that primary key.... What happens if a company needs more numbers? Maybe it's in one of the previous posts. Haven't had time to study...
--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)

July 6, 2009 at 2:46 pm

#1020661
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

wesigler (7/6/2009)
Yes those 3 records are the starting conditions. The example scenario would be a user enters a RangeID of 'D' and the number of Alternating ID's they want...
--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)

July 6, 2009 at 8:25 am

#1020418
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Heh... it does help but there's still one piece of info missing.... so, lemme ask the same question as before...
My apologies for being thick... just trying to figure this 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)

July 6, 2009 at 6:22 am

#1020309
RE: Threw an exception... out of memory

smunson (7/5/2009)
I'm just not curious enough to find out how long the "OR" version would take to run, given the execution plan it generates.
:-):-):-)
What? Unemployed... in search of knowledge......
--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)

July 5, 2009 at 7:53 pm

#1020171
RE: SQL brian teaser...

Digs (7/5/2009)
Thanks all sorted now !
This code is for an ASP.net project, data input comes from 3 textboxes that will out put a string each.
Ok... first, it's a two way...
--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)

July 5, 2009 at 7:44 pm

#1020170
RE: SQL brian teaser...

Lynn Pettis (7/5/2009)
Now, one last little ribbing. You spelled BRAIN incorrectly in you post header. 😛
Heh... Picky, picky, picky...
--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)

July 5, 2009 at 7:42 pm

#1020168
RE: SQL brian teaser...

Digs (7/5/2009)
Ok first thanks to the forum for the function 'DelimitedSplit'
This is my next challenge..
I need to do an insert into a table
FieldA, FieldB, FieldC
From my three data strings like:...
--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)

July 5, 2009 at 5:59 pm

#1020153
RE: Threw an exception... out of memory

Understood on the "business" of education... I do it for at least an hour a day. Kind of like practicing piano. Heh... I thought you had some extreme...
--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)

July 5, 2009 at 5:46 pm

#1020150
RE: Are the posted questions getting worse?

GilaMonster (7/5/2009)
WayneS (7/3/2009)
GilaMonster (7/3/2009)
You laugh. I was speaking with someone recently and he said that he and his team do some SQL development, but nothing complex, no joins or anything.
chuckle...
Makes...
--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)

July 5, 2009 at 5:01 pm

#1020142
RE: Cursor in SQl Server

You bet, Barry... it's good stuff. Is there another installment coming up any time soon?
--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)

July 5, 2009 at 4:56 pm

#1020140
RE: SQL Split query

Very cool, Wayne... Guess I'll transfer all of my test results and explanations to that.
--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)

July 5, 2009 at 4:51 pm

#1020139
RE: Threw an exception... out of memory

I meant to ask... what are you doing this for? What's the business reason, I mean?
--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)

July 5, 2009 at 4:47 pm

#1020138

Viewing 15 posts - 43,066 through 43,080 (of 59,063 total)