Forum Replies Created
Viewing 15 posts - 35,656 through 35,670 (of 59,099 total)
-
RE: Under Appreciated Features
I’ve got a couple in mind already that I’ll post as a comment, but I’d like to hear what you think first. What feature would you tell your fellow...
--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) -
RE: Round to next 1000 or 100 without Ceiling function
parthi-1705 (12/17/2010)
Jeff Moden (12/16/2010)
@ Parthi, Andrew, and Tom,Good Lord... My humble apologies. That's the second time I made such a mistake in this forum this week. And 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) -
RE: Construct an EXECUTE string
Gianluca Sartori (12/17/2010)
It couldn't be otherwise with Jeff helping! 😉You're way too kind. :blush: Thanks, Gianluca.
--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) -
RE: Construct an EXECUTE string
Mac_85 (12/16/2010)
Jeff, I really appreciate the time you've taken to look at this; as that was exactly the issue.Very much appreciated (and red faced for missing a basic date conversion...
--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) -
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (12/17/2010)
and I am on the right....with the American Flag behind me. You just can't see it.Now we're talking! 🙂
--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) -
RE: query to get all childs and grand children for a prent
Thanks for the feedback. You are, of course right about "It Depends". Guess I'll have to yank out some examples of what I ran into on larger hierarchies....
--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) -
RE: SPLITTING A STRING
David Benoit (12/16/2010)
Hey Jeff - I certainly like that function better than most that I have seen and used. One question I do have though; have you noticed that 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) -
RE: Construct an EXECUTE string
Mac_85 (12/16/2010)
Thanks Jeff; I managed to work out how to send the date/time without the periods.However, even as this:
"EXECUTE qDbReports '2010-17-12 07:56:52 AM', '2010-17-12 07:56:53 AM', 88, 1"
I still...
--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) -
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (12/16/2010)
Jeff Moden (12/15/2010)
Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?It depends... where's your other hand? 🙂
A knife, a real knife
Heh... 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) -
RE: Round to next 1000 or 100 without Ceiling function
Lynn Pettis (12/16/2010)
Jeff,Don't worry, mine doesn't fully work properly either. To make it work every time, you have to add enough 9's after the decimal point to fill 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) -
RE: Round to next 1000 or 100 without Ceiling function
@ Parthi, Andrew, and Tom,
Good Lord... My humble apologies. That's the second time I made such a mistake in this forum this week. And I really did 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) -
RE: Round to next 1000 or 100 without Ceiling function
Lynn Pettis (12/16/2010)
Based on code above, please remember that round(value, length, 1) will truncate, not round.Yep... I was counting on that but not on the other mistakes I made.
--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) -
RE: datetime to month - year
andell_ramsay (12/15/2010)
Jeff -How then would one be able to sort chronologically on this field? Is there a way to keep the format while changing the data type to 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) -
RE: Hidden Formatting Troubles with STR() (SQL Spackle)
For all you relatively new folks, I thought I'd help you head off a future problem if you ever need to ask a T-SQL or Performance related question either on...
--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) -
RE: Hidden Formatting Troubles with STR() (SQL Spackle)
Nakul Vachhrajani (12/16/2010)
Thank-you, Jeff! Great series!Thanks, Nakul... I appreciate 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)
Viewing 15 posts - 35,656 through 35,670 (of 59,099 total)