Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,351 through 49,365 (of 59,091 total)

RE: Split integer valuefrom decimal valye

indraprakash (7/7/2008)
Note: We can't use convert function
The ROUND function with the truncate option is definately the way to go... but why is it that you can't use the CONVERT function?
--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)

July 8, 2008 at 2:40 pm

#839774
RE: Congratulations to Our New MVPs

Thanks David... Heh... what I'd really like to do is raise a glass at the bar!: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)

July 8, 2008 at 7:15 am

#839466
RE: Time Calculation

Sorry Robert... "OP" is forum shorthand for "Original Poster".
The thing is that the table I am retrieving the data from is a production/live database and cannot be modified, the formats...
--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)

July 8, 2008 at 6:17 am

#839424
RE: To Certify or Not To Certify

Now, that's something I can definitely agree with! 🙂
--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)

July 8, 2008 at 6:11 am

#839419
RE: eliminating duplicates

harshil (7/8/2008)
Yes Mr. Actually I have read the requirements and I have correctly suggested the intended solution to delete duplicate records.
Although I have intentionally mentioned it for SQL SERVER...
--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)

July 8, 2008 at 6:10 am

#839417
RE: To Certify or Not To Certify

Mark Horninger (7/8/2008)
I have to wonder if the people you're seeing are the exceptions or the rule....
I know one certified person who I worked with that didn't have a clue,...
--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)

July 8, 2008 at 6:03 am

#839411
RE: To Certify or Not To Certify

Mark Horninger (7/8/2008)
Jeff,
Was it a test DB with space issues? Dunno why anyone would want do do that....
Mark
The guy didn't even take the time to find out......
--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)

July 8, 2008 at 5:52 am

#839401
RE: To Certify or Not To Certify

GilaMonster (7/8/2008)
Mark Horninger (7/8/2008)
Jeff,
Was it a test DB with space issues? Dunno why anyone would want do do that....
Mark
I think it was a posting on these forums....
--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)

July 8, 2008 at 5:49 am

#839399
RE: To Certify or Not To Certify

GilaMonster (7/8/2008)
Just to stir things a bit, what's the opinion of the general skill level in our industry (ignoring certified/not certified)?
Based on what I've seen in real life at work...
5%...
--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)

July 8, 2008 at 5:47 am

#839396
RE: Time Calculation

Alright... I was hoping the OP would come up with something himself...
Here's a million rows test table... as usual, read the comments for what each column represents...
--===== Create 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)

July 8, 2008 at 5:35 am

#839388
RE: To Certify or Not To Certify

Yep... same ol' stuff, too! Basically a summary of everything that everyone has spoken of so far except how lame some (supposedly) certified folks "real skills" actually 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)

July 8, 2008 at 4:46 am

#839363
RE: obtain data from 2 weekdays?

No problem, Mick... It's easy to miss stuff especially when it's new.
--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)

July 8, 2008 at 4:34 am

#839355
RE: Time Calculation

There's nothing stopping you from that... think about 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)

July 8, 2008 at 4:32 am

#839353
RE: eliminating duplicates

. EH! Wrong again! You only read the title... you didn't even read the requirements from the first post of the OP. Worse yet, this...
--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)

July 8, 2008 at 4:31 am

#839352
RE: Dropping Stored Procedures

Your wasting a lot of time to maybe get it wrong. I don't normally advocate 3rd party software, but RedGates SQL Compare will do everything you just asked for......
--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)

July 8, 2008 at 4:23 am

#839348

Viewing 15 posts - 49,351 through 49,365 (of 59,091 total)