Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,386 through 35,400 (of 59,099 total)

RE: Better looping - replace for cursor

BaldingLoopMan (1/14/2011)
sorry. i do agree w the indexing just not the loop haters out there
Not to worry... I only hate slow loops... 😉
--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)

January 14, 2011 at 1:37 pm

#1273778
RE: Select column values as comma seperated format

andrewd.smith (1/14/2011)
Something like this should do for a character data type column. A numeric datatype column would just need a cast to a varchar (or nvarchar).
DECLARE @MyList varchar(max)
SET @MyList =...
--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)

January 14, 2011 at 1:32 pm

#1273776
RE: Merge performance on Very Large Tables

zerolan22 (1/14/2011)
To all you DB/SQL experts out there - I hope you can shed some light on my problems.
It sounds from your description as if it may be indexes causing...
--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)

January 14, 2011 at 8:07 am

#1273564
RE: Please help with SQL code

pwalter83 (1/11/2011)
The condition is if value in POL_COUNTRY_CD or POD_COUNTRY_CD column in table NCV_BL_DHL_TEMP begins with FR, then join to MG_LOCATION table to identify continent.
That's the whole problem in 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)

January 13, 2011 at 9:04 pm

#1273406
RE: UPDATE using a self-join

CELKO (1/13/2011)
Lowell (1/13/2011)
Horrible example, Celko; all it proves is the row used to to update the parent table is not guaranteed unless you make sure the joins form a 1: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)

January 13, 2011 at 8:25 pm

#1273404
RE: Are the posted questions getting worse?

Luke L (1/13/2011)
Stefan Krzywicki (1/13/2011)
jcrawf02 (1/13/2011)
Stefan Krzywicki (1/13/2011)
or we could follow Europe and Japan and let people operate vending machines with their phones.
Do what with their phone now? We should...
--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)

January 13, 2011 at 8:04 pm

#1273401
RE: Are the posted questions getting worse?

LutzM (1/13/2011)
Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.
I don't suppose there's a chance of doing it remotely, is...
--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)

January 13, 2011 at 7:58 pm

#1273399
RE: Are the posted questions getting worse?

Roy Ernest (1/13/2011)
This place rocks... I ask for help and I get tons of help. This is the second time I asked for help here and both the times 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)

January 13, 2011 at 7:56 pm

#1273398
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/13/2011)
If they see a penny on the ground, they leave it there.
Maybe other folks will leave it, but I'll stop and pick it up. I've got 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)

January 13, 2011 at 7:53 pm

#1273396
RE: Are the posted questions getting worse?

Grant Fritchey (1/13/2011)
SQLkiwi (1/13/2011)
Grant Fritchey (1/13/2011)
Thank you very much. I've already shot this one in the head. I was working off a bad notion of how heaps are stored, so...
--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)

January 13, 2011 at 7:48 pm

#1273395
RE: Are the posted questions getting worse?

Jan Van der Eecken (1/13/2011)
Ray K (1/13/2011)
Ray K (1/12/2011)
Hey Threadizens -- I could use some advice on what I hope is a quick and easy question!
Thank you, fellow Threadizens, for...
--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)

January 13, 2011 at 7:45 pm

#1273393
RE: substring funcation.

mister.magoo (1/13/2011)
Jeff Moden (1/13/2011)
mister.magoo (1/13/2011)
Jeff Moden (1/12/2011)
I'm a lightweight when it comes to XML. What are the two slashes and the [1] for?
The two slashes are the XML equivalent...
--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)

January 13, 2011 at 7:38 pm

#1273390
RE: SQL help needed with a split function sql server 2008

Sichy (1/13/2011)
Ahhh yes i see. Thanks again Jeff your help is greatly appreciated!
JS
You bet. Thanks 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)

January 13, 2011 at 7:25 pm

#1273386
RE: substring funcation.

mister.magoo (1/13/2011)
Jeff Moden (1/12/2011)
I'm a lightweight when it comes to XML. What are the two slashes and the [1] for?
The two slashes are the XML equivalent of 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)

January 13, 2011 at 8:15 am

#1273076
RE: Display name of months in a matrix report

pwalter83 (1/12/2011)
Hi Jeff,
Thanks for your reply. What I want to know is how can I change the format of the date on the SSRS matrix report. I wish to display...
--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)

January 13, 2011 at 8:13 am

#1273074

Viewing 15 posts - 35,386 through 35,400 (of 59,099 total)