Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,256 through 42,270 (of 59,067 total)

RE: How to divide results into two somewhat-equal piles?

Beverly,
I guess it's a difference in language... In the absence of anything else, I erroneously took your saying you were going on "holiday" to mean on "vacation". Like 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)

August 17, 2009 at 6:22 pm

#1040593
RE: Date Range

Ah... I hate it when that happens. 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)

August 17, 2009 at 12:56 pm

#1040427
RE: Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

jeff (8/16/2009)
I assumed (possibly incorrectly) that people would be more likely to answer a general question rather than puzzling through the details of my specific code.
To elaborate on my previous...
--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)

August 17, 2009 at 12:54 pm

#1040426
RE: How to divide results into two somewhat-equal piles?

Here's what you said, Beverly...
Thanks so much for the replies, guys! I'm on holidays for a week but will try these out when I get back!
Think about it... based...
--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)

August 17, 2009 at 12:32 pm

#1040412
RE: Date Range

bpowers (8/17/2009)
I got it working. Thanks.
Heh... got what working? Did you use Jeff's algo or something else? Two way street here... let us know please. Thanks.
--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)

August 17, 2009 at 12:01 pm

#1040393
RE: Please point me in the right direction

I agree... if the outgoing DBA is leaving of his/her own free will and is friendly about the whole thing, I recommend "belt looping" that person ever day you can....
--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)

August 17, 2009 at 11:50 am

#1040383
RE: sql function - null parameter

I believe that is correct... you actually have to use the word "DEFAULT" for unknown parameters in a function.
You should also be aware that functions cannot return result sets directly....
--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)

August 17, 2009 at 11:44 am

#1040380
RE: Name value pair (EAV) model

Heh... c'mon.... EAV's and NVP's are cool. You can put the entire database in one table and you only have to worry about maintenance on one index. :-P:-P:-P
--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)

August 17, 2009 at 10:42 am

#1040356
RE: Issue with assigning candidates to a review list

Good job on the workaround, Wayne.
Heh... Barry... nice job. You deserve the title Mr. "There must be 15 ways 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)

August 17, 2009 at 9:58 am

#1040307
RE: Are the posted questions getting worse?

Roy Ernest (8/17/2009)
Thank God that I dont write blogs... At least meaning full blogs. I have only moaned on my blog and no technical stuff... I am clever, keep away...
--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)

August 17, 2009 at 9:36 am

#1040280
RE: Are the posted questions getting worse?

GilaMonster (8/17/2009)
Jeff Moden (8/17/2009)
Heh... yeah, but being the responsible person you are, I'll bet you went back and fixed it as soon as you realized the mistake.
He went...
--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)

August 17, 2009 at 9:23 am

#1040270
RE: Are the posted questions getting worse?

GSquared (8/17/2009)
Heh... if the eyes reveal the soul, the blog reveals the mind.
I'm nearly blind (can see about 6 inches without glasses), and my blog is empty ... the implications...
--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)

August 17, 2009 at 9:21 am

#1040268
RE: How to trim the decimal places?

Thanks for the feedback, Tatoba.
--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)

August 17, 2009 at 8:59 am

#1040253
RE: Are the posted questions getting worse?

Grant Fritchey (8/17/2009)
Jeff Moden (8/15/2009)
GilaMonster (8/15/2009)
Jeff Moden (8/15/2009)
Yeah... I love people's blogs... 😛
Ok, now I'm worried....
Heh... please don't be. Your blogs are the epitome of what every DBA 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)

August 17, 2009 at 8:40 am

#1040233
RE: Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

OPTION F... Single "Quirky Update"
Problem: Post to too abstract to help.
--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)

August 16, 2009 at 10:20 pm

#1040013

Viewing 15 posts - 42,256 through 42,270 (of 59,067 total)