Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,661 through 45,675 (of 59,101 total)

RE: insert using cursor or store proc

The other part of the problem is the concatenations and the formulas on columns. No chance of an index being used for anything practical there.
Also, you're inserting into 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)

January 22, 2009 at 9:10 pm

#931616
RE: Need assistance avoiding rbar

Heh... you've just gotta know that any post with "RBAR" in the title is going to catch my eye. Thought I'd stop by and see what's up. Looks...
--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 22, 2009 at 9:03 pm

#931612
RE: Open Source Pay

mtucker (1/22/2009)
If someone sees that you are doing a lot more work than them for the same salary they have a very good incentive to work harder. They would not...
--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 22, 2009 at 8:44 pm

#931611
RE: Why do people need to do this?

Yep... I do the same thing... except I've been solving the problem and then asking for a bit of feedback. Of course, once the cat's out of the bag,...
--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 22, 2009 at 8:11 pm

#931598
RE: Open Source Pay

mtucker (1/22/2009)
Jeff Moden (1/22/2009)
How are my fellow employees going to make better decisions if they know what I make?
better decisions with regard to their salary and conditions...should i ask 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 22, 2009 at 8:01 pm

#931592
RE: backup failure

I'm thinking it was a coincidence... not sure though... looks like one of those times when you "had to be there" to figure it out. I've never seen 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)

January 22, 2009 at 7:35 pm

#931585
RE: VM... Setting up new "box"

Steve Jones - Editor (1/22/2009)
Jeff, I'm sure you're part of the problem 😛
Exactly... if it weren't for me asking for stuff they said they could provide, they wouldn't have...
--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 22, 2009 at 7:28 pm

#931580
RE: VM... Setting up new "box"

Michael Earl (1/22/2009)
especially coming from someone like yourself
That the heck is that supposed to mean?
Once again - just kidding.
See? That's what I mean... 😛 I'm just about 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)

January 22, 2009 at 7:26 pm

#931579
RE: Are the posted answers getting worse?

My all time favorite... "I have 3 tables... yada-yada-yada... how do I join them?" I have to admit, I don't even bother answering those anymore. Not 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 22, 2009 at 7:24 pm

#931577
RE: What are the Party Plans?

Michael Earl (1/22/2009)
http://www.wisconsinmade.com/gift-ideas/Bone-in-Stuffed-Pork-Chops-2560.aspx?DepartmentId=1252
Mmmmmm... tasty... expensive, but tasty.
--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 22, 2009 at 7:20 pm

#931576
RE: SQL or Oracle

So! Anybody wanna talk about all the companies that use spreadsheets like databases? I'll start... I hate them all. 😛
--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 22, 2009 at 7:15 pm

#931574
RE: Why do people need to do this?

Bob Hovious (1/21/2009)
I haven't scrolled through all 60 or so messages to see if this was mentioned so it may be redundant.
I sometimes get one-shot requests for a simple CSV...
--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 22, 2009 at 7:04 pm

#931572
RE: convert DateTime to BigInt

J (1/22/2009)
The OP has ignored repeated requests as to the WHY of it.
On top of that he has been warned repeatedly that is a bad idea.
If all he wants 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 22, 2009 at 6:54 pm

#931571
RE: Concatenating Field Values

ric (1/20/2009)
I don't want to concatenate 2 different fields I want to concatenate all of a particular Field.
So if Column is Total and Rows are days of week. Mon=1,Tue=2,Wed=3,Thur=4,Fri=5. In...
--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 22, 2009 at 6:51 pm

#931570
RE: Correct use of @variables and uniqueidentifiers

PG (1/22/2009)
GilaMonster, GSquared, Jeff Moden,
You guys are killing me here 😛 !!! I mean, "Pork chop thru the nose", now that's funny :w00t:.
To quickly end the suspense, I am 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 22, 2009 at 6:41 pm

#931568

Viewing 15 posts - 45,661 through 45,675 (of 59,101 total)