Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,746 through 50,760 (of 59,091 total)

RE: Fetch Row by Row with out using cursor

Thank you for the feedback 🙂
--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)

May 6, 2008 at 5:56 am

#811122
RE: Parsing a cell into multiple rows

Like I said, the data needs to be made more consistent... and the code below does that. About all you need to do is change the path to 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)

May 6, 2008 at 5:47 am

#811116
RE: Parsing a cell into multiple rows

wdillon (5/5/2008)
Hi Jeff
Hum, you are right, it's pretty messed up. I'll attach a zip file of the orginal and see if that works.
Thanks
Bill
Thanks... that's a lot better.
Suggestion on using...
--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)

May 6, 2008 at 2:11 am

#811059
RE: Fetch Row by Row with out using cursor

shalini_pdi (5/5/2008)
I have followed the same procedure as u have mentioned. Its working fine. If i execute the code more than once i got the error as There...
--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)

May 6, 2008 at 12:04 am

#811020
RE: Tally Table

GSquared (5/5/2008)
Another excellent article on tally/numbers tables is at:
http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/
by the lovely Robyn Page and the hillarious Phil Factor (I hope I didn't get that backwards 🙂 ).
The only thing I...
--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)

May 5, 2008 at 11:32 pm

#811014
RE: Cursor not working

Levoin (5/5/2008)
Hi Jeff,
Thank you for you answer. Helps a lot.
What's the problem with cursors?
Franck
Two things... first, they consume more resources and locks than necessary... those can be mostly overcome 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)

May 5, 2008 at 9:42 am

#810783
RE: How to import data from a CSV file?

Thanks for the feedback, Sergey!
--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)

May 5, 2008 at 9:28 am

#810774
RE: Running Total variable resolution

Keith DuAime (5/5/2008)
That article, great by the way, is where I got the idea from. I realized I forgot the with index hint and then also added option(maxdop 1) 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)

May 5, 2008 at 8:43 am

#810727
RE: Performance Problem

GilaMonster (5/5/2008)
Here's something:
Working with tempdb in SQL Server 2005
Thanks, Gail... That's one of the ones I was trying to find... I can't find the other one that explains the "why"...
--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)

May 5, 2008 at 8:08 am

#810700
RE: Query Analyzer behaves differently

Maybe I've not had enough coffee... or maybe just too much scotch.
How do you check the production execution plan without getting QA involved, Barry?
--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)

May 4, 2008 at 11:30 pm

#810528
RE: spid identified as being blocked by itself

john pan (5/4/2008)
thanks for your replies -
what do you mean by recompiling for each row updated?
Are you saying that the query plan is being re-evaluated for each time a row...
--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)

May 4, 2008 at 11:28 pm

#810527
RE: Parsing a cell into multiple rows

Do you have the original file? SOmeone obviously tried to change the first one... even a computer couldn't screw things up that badly... takes a human beinging to mess...
--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)

May 4, 2008 at 11:25 pm

#810526
RE: Selecting list of month numbers between two dates

Thank you for the feedback... but we'd all be interestd in what you actually meant...
--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)

May 4, 2008 at 10:12 pm

#810516
RE: transfer data from a text file

Though shalt not double post... go to your other post and answer the questions that I asked.
--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)

May 4, 2008 at 9:53 pm

#810508
RE: Very Very Urgent......Select data

And, why do you think this is very very "urgent"?... It's been 9 hours since you've posted and 7 hours since the first response... yet, you've not replied 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)

May 4, 2008 at 9:50 pm

#810507

Viewing 15 posts - 50,746 through 50,760 (of 59,091 total)