Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,356 through 44,370 (of 59,097 total)

RE: Are the posted questions getting worse?

Same here, Roy. Our thoughts are with 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)

April 6, 2009 at 7:34 am

#972516
RE: The T-SQL Paradigm

Aaron N. Cutshall (4/6/2009)
David Walker (4/3/2009)
Although this is off the original topic, I still haven't seen a SQL statement that was easier to read with the aliases than without them....
--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)

April 6, 2009 at 7:11 am

#972490
RE: The T-SQL Paradigm

Manie Verster (4/6/2009)
To get SQL to perform is what might make it look difficult. It's easy to write a query but to get the optimal performance out of that query...
--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)

April 6, 2009 at 6:53 am

#972478
RE: T-Sql rant

steve dassin (4/6/2009)
Sergiy (4/6/2009)
steve dassin (4/5/2009)
getting sql folks to get their head out of what is essentially a 'constant' (an sql table) and into something that is variable.
Such 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)

April 6, 2009 at 6:48 am

#972471
RE: T-Sql rant

steve dassin (4/5/2009)
I'm not trying to sell you anything. I'm trying to get you to go in for some trippy stuff 🙂
Heh... it's some trippy stuff, alright. I've never...
--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)

April 6, 2009 at 6:41 am

#972467
RE: T-Sql rant

Mike C (4/5/2009)
Oracle is good about implementing new features and functionality really quickly... sometimes they even get their features out to market before the ISO standards updates are approved.
That's...
--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)

April 6, 2009 at 6:22 am

#972451
RE: How to find the one_space string in a CHAR data type?

Heh... ok... understood. And absolutely spot-on with the rest of what you said. Thanks, Paul. And good "meeting" 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)

April 5, 2009 at 7:59 pm

#972248
RE: How to find the one_space string in a CHAR data type?

I stand corrected. Thanks for the code.
I'd be curious to know why anyone would want to use the difference between an empty string and a sting of 1 or...
--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)

April 5, 2009 at 11:12 am

#972189
RE: T-Sql rant

steve dassin (4/4/2009)
Mike C (4/4/2009)
Jeff Moden (4/4/2009)
steve dassin (4/4/2009)
C'mon do you really have something against parentheses?
Actually, yeah. 😉
Personally I hate those curly braces. Growl.
C'mon you got something against the three...
--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)

April 5, 2009 at 10:46 am

#972179
RE: T-Sql rant

steve dassin (4/4/2009)
C'mon do you really have something against parentheses?
Actually, yeah. 😉
--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)

April 4, 2009 at 9:33 pm

#972126
RE: How to find the one_space string in a CHAR data type?

apat (4/4/2009)
So, second row gives 1 as a result whereas there is actually no space between quotes. It should give 0....
That's what I was saying... you cannot get what 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)

April 4, 2009 at 9:18 pm

#972125
RE: Rounding Problem

Leo (4/2/2009)
Hello Everyone,
I have some problem in table to round up some values.
Example 1. value(declared as money) is 0.1234 base on 0.001 round up, final value will...
--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)

April 4, 2009 at 11:43 am

#972092
RE: datatype to store files

I would imagine that IMAGE or VARBINARY would do the trick. See Books Online for the details.
--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)

April 4, 2009 at 11:30 am

#972089
RE: how to replace uncounted multiple commas into one comma

Ramesh (4/4/2009)
vijays (4/4/2009)
Nice one, but frankly i m not satisfied with Mr. Ramesh answers, because i run and tried the query and found that sometimes it shows incorrect output. Sorry...
--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)

April 4, 2009 at 10:58 am

#972085
RE: how to replace uncounted multiple commas into one comma

vijays (4/4/2009)
Nice one, but frankly i m not satisfied with Mr. Ramesh answers, because i run and tried the query and found that sometimes it shows incorrect output. Sorry Boss...
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)

April 4, 2009 at 10:08 am

#972072

Viewing 15 posts - 44,356 through 44,370 (of 59,097 total)