Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,066 through 46,080 (of 59,095 total)

RE: How to populate 1 row multi field from 3 rows single field

eddy (1/8/2009)
if i try to run it now im not getting 2 rows with 3 prices each but i get 3 rows because the date filed is not the same...
--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 8, 2009 at 6:36 am

#923264
RE: Two different columns to one single column (JOIN)

You'll obviously need to reference table 2 more than once as if it were a separate table for User1 and User2 in table 1. To do that, just 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)

January 8, 2009 at 6:17 am

#923251
RE: How to populate 1 row multi field from 3 rows single field

eddy (1/8/2009)
Hi chrism,
Tnx this seems to work for the example,
Now i going to try to implement this with an update statement
my original temptable has this structure and i foresee...
--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 8, 2009 at 6:14 am

#923246
RE: Lookup table design question

Hussain (1/7/2009)
Please note this new child table will have parent-child relationship with itself.
Ummmm... that's ok so long as you understand the future ramifications and the code required of having such...
--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 8, 2009 at 6:10 am

#923244
RE: Just For Fun: An Impossible Delete

I agree they need to be told and I very much appreciate you going to bat on this subject... but folks, especially folks like myself, can and should do it...
--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 8, 2009 at 5:52 am

#923233
RE: Just For Fun: An Impossible Delete

Your point is very well taken and I'm sorry to disappoint. It's been a bit insane on my side of the house with this very problem of people just...
--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 7, 2009 at 10:57 pm

#923094
RE: Just For Fun: An Impossible Delete

RBarryYoung (1/7/2009)
Personally, I think that it is some kind of psychological "blind spot" that makes them think that they know what this is before they read the whole description, 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)

January 7, 2009 at 8:15 pm

#923059
RE: Temp tables vs. table variable speeds, temp tables faster???

That's a cool example, Kevin. But, if you keep telling people how bad these things are, they may actually stop using them someday and that'll be one less way...
--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 7, 2009 at 7:54 pm

#923050
RE: Just For Fun: An Impossible Delete

Shaun McGuile (1/7/2009)
Someone failed to read the parameters.....like that'll ever happen. 😉
'You can educate some of the people some of the time, but not all of the people all of...
--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 7, 2009 at 7:49 pm

#923048
RE: Just For Fun: An Impossible Delete

RBarryYoung (1/7/2009)
Heh. I'm telling you, there's got to be at least a graduate thesis in Psychology or Communication on this. 🙂
What's really sad and spooky at the same...
--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 7, 2009 at 7:46 pm

#923046
RE: Tips for New DBAs

aprasy (1/6/2009)
Hi everyone,
I am sql developer. I studied ur article...
--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 7, 2009 at 7:37 pm

#923042
RE: Are the posted questions getting worse?

Steve Jones - Editor (1/7/2009)
Properly cut? Since when do those in MI know meat? Aren't you more the cheese and beer crowd with your neighbors?
BWAA-HAAA!!!! We know meat plenty...
--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 7, 2009 at 7:01 pm

#923032
RE: CDOSys and Identical code

BWAAAAA_HAAAAA-HAAAAA!!!!!! Oh shoot! I hate "nuances". I got it to work on all servers and I'm trying to figure out which of the differences between the old 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)

January 7, 2009 at 4:34 pm

#922993
RE: CDO.Message.1The "SendUsing" configuration value is invalid.

Stacy (6/13/2006)
Borik,
I ran your code and received the error. After changing 'cdoSendUsingPort' & 'cdoBasic' to '2' & '1' respectively, the email was sent correctly. Do you know what values 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)

January 7, 2009 at 4:25 pm

#922991
RE: CDOSys and Identical code

Heh... OK... first of all, I'm not using DTS for any of this. Second, the SQL Server Agent, the Server itself, and I are all logging in as 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 7, 2009 at 3:10 pm

#922952

Viewing 15 posts - 46,066 through 46,080 (of 59,095 total)