Jeff Moden

Forum Replies Created

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

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
RE: Open Source Pay

mtucker (1/22/2009)
Exactly! Full disclosure of salaries allows people to make better decisions because they have more information.
How are my fellow employees going to make better decisions if they know what...
--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:09 pm

#931566
RE: The Set-Based Limit

GSquared (1/22/2009)
Needed in batches of about 5-10,000 at a time, usually about 100k per week.
So, there's on situation where I consider procedural code valid.
Are you saying it took overnight 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)

January 22, 2009 at 5:54 pm

#931564
RE: Correct use of @variables and uniqueidentifiers

GSquared (1/22/2009)
Because violations of first normal form are so much fun! And the entertainment value from trying to work out delete and update code for string lists is enough...
--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 12:24 pm

#931385
RE: Correct use of @variables and uniqueidentifiers

PG... although we're having a bit of fun at the expense of your dilema, it would be good to know why (the actual business reason) the table is denormalized 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 12:22 pm

#931383
RE: The Set-Based Limit

peter (1/22/2009)
Jeff, any luck in finding the saved "function argument" you mentioned?
No, sorry... I can't even remember who the "argument" was with...
Touch a minimal set of data, 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 12:18 pm

#931379
RE: Is Vince Iacoboni still around?

Yep... that's the one. And, after reading that bad boy, I have to say that the feeling is mutual, Vince. 🙂
--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 12:05 pm

#931371

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