Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,476 through 41,490 (of 59,102 total)

RE: TSQL Question about getting data

Ok, I guess I have a question or two...
If a Case code (like 29119) has two values of CurrentGluedPieces of 0 and 91520 for each day and shift, how do...
--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)

October 19, 2009 at 7:51 pm

#1067904
RE: TSQL Question about getting data

Thanks Brad... just got home from work and looking at this now...
--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)

October 19, 2009 at 7:30 pm

#1067895
RE: Discussion: Removing the option to ' SELECT * FROM OBJECT'

I do it the same way... and every step is tested that way as Gail and Gus. The side benefit is that every step is tested.
--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)

October 19, 2009 at 7:28 pm

#1067893
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/19/2009)
Bob Hovious 24601 (10/18/2009)
Where'd you get the hat? I have to make do with a colander reinforced with tin foil.
I think we'd like pictures...
--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)

October 19, 2009 at 7:15 pm

#1067888
RE: Are the posted questions getting worse?

RBarryYoung (10/18/2009)
Jeff Moden (10/18/2009)
Bob Hovious 24601 (10/17/2009)
I don't know, Jeff. After seeing the kindler/gentler you in action in that "urgent" thread that the OP never came back...
--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)

October 18, 2009 at 11:31 pm

#1067519
RE: Are the posted questions getting worse?

Bob Hovious 24601 (10/18/2009)
Where'd you get the hat? I have to make do with a colander reinforced with tin foil.
Heh... it was actually a large tin plate 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)

October 18, 2009 at 11:29 pm

#1067518
RE: Complete Newbie Needing Guidance...

RBarryYoung (10/18/2009)
Jeff Moden (10/18/2009)
You know, it would probably be the shortest article ever, but you should submit your post as an article. This question seems to get asked over...
--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)

October 18, 2009 at 11:22 pm

#1067516
RE: Complete Newbie Needing Guidance...

RBarryYoung (10/18/2009)
Jbrandonmay (10/18/2009)
Thank you very much Jeff those are all outstanding suggestions and a great gameplan. Also I agree with the other poster this really should be a sticky.
Heh, story...
--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)

October 18, 2009 at 11:20 pm

#1067515
RE: Complete Newbie Needing Guidance...

Jbrandonmay (10/18/2009)
Thank you very much Jeff those are all outstanding suggestions and a great gameplan. Also I agree with the other poster this really should be a sticky.
Actually, if you...
--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)

October 18, 2009 at 11:19 pm

#1067514
RE: BULK INSERT DATE

Very cool feedback, Karen. "fricking booger" had me laughing so hard that I blew a pork chop out of my nose. 😛
Not that it will matter but tell your...
--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)

October 18, 2009 at 11:15 pm

#1067512
RE: Are the posted questions getting worse?

Nah... I wear a grounded tin hat while I'm posting. 😛 I just plugged it into a wall outlet by mistake that day. 😛
--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)

October 18, 2009 at 8:56 pm

#1067498
RE: Add column to subscriber table

Thanks for the info, HappyCat... I haven't had to worry much about replication in the past...
--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)

October 18, 2009 at 8:46 pm

#1067494
RE: A Wish list for the Microsoft Flying Squad

Agreed and that's part of my point. The managers need to stop trivializing and take control/ownership of their projects. If work is lost just because an employee (at...
--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)

October 18, 2009 at 8:37 pm

#1067491
RE: Complete Newbie Needing Guidance...

You know, it would probably be the shortest article ever, but you should submit your post as an article. This question seems to get asked over and over 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)

October 18, 2009 at 8:28 pm

#1067489
RE: Are the posted questions getting worse?

Bob Hovious 24601 (10/17/2009)
I don't know, Jeff. After seeing the kindler/gentler you in action in that "urgent" thread that the OP never came back to, I'd say...
--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)

October 18, 2009 at 8:10 pm

#1067488

Viewing 15 posts - 41,476 through 41,490 (of 59,102 total)