Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,086 through 35,100 (of 59,099 total)

RE: loop in function

L09041975 (2/13/2011)
Is it possible to write a loop in a function? I'm getting the following error:
"Cannot access temporary tables from within a function"
Is there a work around? :crazy:
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)

February 14, 2011 at 12:11 am

#1286301
RE: Tuning on parallel processing

sql_butterfly (2/13/2011)
I checked all almost all of the things. Everything looks fine to me. However there is one update which affects around one thousand rows (on an average) on a...
--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)

February 13, 2011 at 11:58 pm

#1286297
RE: Are the posted questions getting worse?

Craig Farrell (2/13/2011)
Koen Verbeeck (2/13/2011)
You are certainly right. I'm afraid I didn't make myself clear with my statement.
The developer shouldn't be the only one who is testing his code. Unfortunately...
--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)

February 13, 2011 at 11:55 pm

#1286295
RE: ##Tables in concurrent environment

Anamika (2/13/2011)
On the basis of the value is not null I'm adding those in to where conditions. while doing this i want to find the IDs from a comma separated...
--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)

February 13, 2011 at 11:46 pm

#1286293
RE: Proc runs slow only during business hours?

sqldba_icon (2/13/2011)
I have a proc which takes 2secs to finish when there is minimal load on the server( night times) and takes 30 secs during day times. Mentioned below are...
--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)

February 13, 2011 at 11:41 pm

#1286292
RE: CTE Query Parent/Child Struggles

Ack! I just reread your requirements. The part about multiple-parents for a given category ID isn't something easily resolved. Are you sure about the "multiple-parents" thing?
--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)

February 13, 2011 at 11:37 pm

#1286287
RE: CTE Query Parent/Child Struggles

malik.robinson (2/13/2011)
Thanks for the warm welcome on my first post in this forum. I tried to be brief purely to avoid a long monolithic post.
I will keep trying 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)

February 13, 2011 at 11:35 pm

#1286286
RE: Datewise Cummulative total for particular customer

Now be careful folks. You've both built Triangular Joins which can be literally millions of times worse than a cursor. If you don't want to use the "Quirky...
--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)

February 13, 2011 at 11:24 pm

#1286282
RE: parse XML using sql

mister.magoo (2/13/2011)
Jeff, you gotta learn some XML !
Ok... how about an article on it? 😀
In the meantime, care to explain the code you wrote so an XML dummy like me...
--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)

February 13, 2011 at 11:16 pm

#1286278
RE: PURPOSE OF TEMPORARY TABLES

SQLCHILD (2/13/2011)
Dear Jeff Sir,
Thanks a lot for your reply, i also wanted to know that how do temporary tables hold the result set of a stored procedure. i have read...
--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)

February 13, 2011 at 11:07 pm

#1286276
RE: Query - Array

That's likely going to be quite slow because of the While Loop.
Your function will spilt single City.But i have to split some array of City
Why? :blink:
--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)

February 13, 2011 at 12:57 pm

#1286186
RE: newbie - need help tweaking this script to make data in 1 db column parsed and extracted to 3 columns

One of the better ways to do this would be to do a BULK INSERT using "|" as the delimiter.
That, notwithstanding, I agree that a "Tally Table" based splitter function...
--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)

February 13, 2011 at 12:40 pm

#1286183
RE: SQL Query -- need help

gary.morey (1/31/2011)
Thank you. That did it!
Heh... stop using font sizes, Gary. The defaults are just fine. 😉
--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)

February 13, 2011 at 11:59 am

#1286179
RE: Crap Query.... Anyone help tune it in better way

sql_butterfly (2/4/2011)
We have four tables Table1, Table1, Table3, Table4 in differernt databases. There are common fields Department, ProcessDate and ProcessId i these tables. The processes are getting processed and putting...
--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)

February 13, 2011 at 11:56 am

#1286178
RE: parse XML using sql

I pretty much suck when it comes to handling XML. 😀
Does anyone have an answer for this?
--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)

February 13, 2011 at 11:43 am

#1286176

Viewing 15 posts - 35,086 through 35,100 (of 59,099 total)