Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,251 through 41,265 (of 59,102 total)

RE: Query to show dates in columns

Before you trot off, answer a question for me, please. Why did you need to format data in this manner?
I also noticed that you didn't get your dynamic date...
--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)

November 7, 2009 at 7:54 pm

#1076398
RE: A Bad Litmus Test

I agree... it's a very bad Litmus test. It's more like a ring-knockers club and it shows a very narrow mind.
--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)

November 7, 2009 at 7:47 pm

#1076397
RE: null values

David Portas (11/7/2009)
In either SQL or Oracle you can use COALESCE, which is the Standard SQL function instead of ISNULL and NVL which are non-standard.
Why do you think that's so...
--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)

November 7, 2009 at 7:22 pm

#1076396
RE: Data allocation in B-tree

Heh... why do you care? It's not like you'll be able to change it or take advantage of 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)

November 7, 2009 at 7:06 pm

#1076395
RE: Date Conversion problem again

This will solve the problem of finding everyone 71 years of age or older and still stand a chance of using an index... of course, it's untested because you didn't...
--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)

November 7, 2009 at 7:03 pm

#1076394
RE: update command

Paul White (11/7/2009)
I know not everything in life is about performance...
BWAA-HAA!!! 😛
--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)

November 7, 2009 at 9:15 am

#1076353
RE: Import data from csv file

Heh... I LOVE batch files. 😛
Point well taken, though. I've been put off of SSIS (and, previously, DTS) because of what I've seen people do with it... they can't...
--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)

November 7, 2009 at 8:22 am

#1076348
RE: Performance Expectations w/ Transactional Replication

Thanks for the info and the corrections. Although replication certainly has some good uses, I'll always think of it as a bit of a pain because of problems as...
--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)

November 7, 2009 at 8:11 am

#1076345
RE: Are the posted questions getting worse?

Bob Hovious 24601 (11/6/2009)
F_PC = M_Bone*A_Meat
Moden's Law?
Heh... you've just given me an idea for a "fun" article. Thanks, Bob.
--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)

November 7, 2009 at 8:02 am

#1076340
RE: URGENT: Combining Stored Procedure Output in single result set

deepakkn (11/6/2009)
Hi,
I want to combine the output of multiple stored procedures in a single result set.
The output columns of all the stored procedures will be same.
Ex:
EXEC sp_getClientsList
UNION ALL
EXEC sp_getClientsList
I agree...
--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)

November 7, 2009 at 7:51 am

#1076336
RE: URGENT: Combining Stored Procedure Output in single result set

Thanks for the info, Paul.
Switching gears... I'll always be humble when it comes to something I don't know, though. 🙂 It's just my nature.
--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)

November 7, 2009 at 7:43 am

#1076332
RE: URGENT: Combining Stored Procedure Output in single result set

deepakkn (11/6/2009)
Thanks for the Reply Paul.
We had a thought about SSIS packages.But that would hamper my performance.
Paul... like the other post, not being snarky here... I just don't know 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)

November 6, 2009 at 11:35 pm

#1076253
RE: Inspiring Change

Heh... what's really funny about that is I've seen the same thing. And, they all knew that boots had straps but didn't know what a boot looked 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)

November 6, 2009 at 10:31 pm

#1076240
RE: Sum(ISNULL(GSTExclusiveAmt,0))

Paul White (11/6/2009)
[font="Courier New"]Warning: Null value is eliminated by an aggregate or other SET operation.[/font]
(suppressed by SET ANSI_WARNINGS OFF)
Correct on both counts... except for distributed transactions (IIRC).
--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)

November 6, 2009 at 10:19 pm

#1076239
RE: How to momentarily stop SQL Server 2005 Transactional Replication?

talltop-969015 (11/6/2009)
Just because a block change has been tested in DEV and QA does not necessarily guarantee that same code is going to work in a production environment every single...
--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)

November 6, 2009 at 10:04 pm

#1076236

Viewing 15 posts - 41,251 through 41,265 (of 59,102 total)