Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,501 through 43,515 (of 59,097 total)

RE: Help Needed ???

Heh... no, I had the right post.
No one has correctly defined what the "first ten" will be. Without something to do an ORDER BY in the data, 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)

June 9, 2009 at 9:20 pm

#1007172
RE: Help Needed ???

Sorry... wrong post.
--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)

June 9, 2009 at 9:15 pm

#1007169
RE: Sort by Reads or Ratings

Jason Crider (6/9/2009)
How difficult would it be to have a section for scripts that would allow you to do a sort by rating, reads, or date? What about 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)

June 9, 2009 at 9:08 pm

#1007168
RE: Mining for Quitters

Obviously not directed at Steve... this type of thing is a big steaming pile of hooie. Everyone thinks they can figure out humans with numbers and stats. Try...
--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)

June 9, 2009 at 9:00 pm

#1007166
RE: Week numbers and week start dates

balars_2000 (6/9/2009)
hi mate
thanks for ur response; appreciate it.
sorry if i wasnt clear, i need week numbers and week start dates for any given date range or a year. if 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)

June 9, 2009 at 8:56 pm

#1007165
RE: O(n) , O(n log n), O(n^2)

O(wtf²) 😉
--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)

June 9, 2009 at 7:26 pm

#1007149
RE: What is the equivalent to Yes/No data type in SQL?

With that thought in mind, even the BIT datatype is tri-state... Yes, No, an dunno (NULL)
--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)

June 9, 2009 at 7:20 pm

#1007147
RE: charindex help

hugh.mileshkin (6/9/2009)
Thanks so much for your help Jeff & John, really appreciate it! 🙂
Thanks, Hugh. Good feedback like that is the only pay we get for this type 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)

June 9, 2009 at 7:17 pm

#1007145
RE: Forums on your Resume/CV

GilaMonster (6/9/2009)
He turned it down, because his current company had offered him a raise if he would stay.
Yowch! I have some pretty strong feelings about that. 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)

June 9, 2009 at 7:12 pm

#1007143
RE: Forums on your Resume/CV

jcrawf02 (6/9/2009)
Let the record state officially that I have never observed RBarryYoung to in any way condone inappropriate behavior of this sort, and that my post relating to his unfortunate...
--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)

June 9, 2009 at 7:09 pm

#1007142
RE: Random problems

Mike C (6/9/2009)
drogers (6/9/2009)
A minor quibble with the article: the problem is not that RAND() is called multiple times with the same seed, once per row. The problem is 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)

June 9, 2009 at 7:02 pm

#1007141
RE: Random problems

drogers (6/9/2009)
Jeff Moden (6/9/2009)
RAND() in T-SQL works exactly the same way as RAND() in any computer language.... one row or value at a time.
No, it doesn't work at all like...
--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)

June 9, 2009 at 6:59 pm

#1007139
RE: Random problems

Heh... in that case, no. NEWID() is random enough as a seed.
--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)

June 9, 2009 at 12:18 pm

#1006982
RE: Are the posted questions getting worse?

GilaMonster (6/9/2009)
Gee Barry
RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of the length...
--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)

June 9, 2009 at 12:16 pm

#1006981
RE: Are the posted questions getting worse?

Lynn Pettis (6/9/2009)
Jeff Moden (6/9/2009)
Lynn Pettis (6/9/2009)
Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...
Which tread?...
--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)

June 9, 2009 at 12:11 pm

#1006978

Viewing 15 posts - 43,501 through 43,515 (of 59,097 total)