Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,151 through 45,165 (of 59,101 total)

RE: Query output to txt file & columnheader headers

J (2/16/2009)
Cast the output as CONVERT(VARCHAR(DesiredColumnWidthHere), long_column_name) AS long_column_name.
Interesting.
So I suppose this is more efficient than SUBSTRING ?
Regards
Sorry to use the ol' cliche`, but it depends... sometimes SUBSTRING won'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)

February 16, 2009 at 10:45 am

#944722
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

David Jackson (2/16/2009)
Ours is not to reason why, but to do and die... :Whistling: 🙂
Heh... I really hate it when THAT happens. 😛
--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)

February 16, 2009 at 10:42 am

#944718
RE: Rollback the job running very long time

sunny1_liu (2/15/2009)
Yeah, I understand that. But the question is that the job runs well all the time, it amazing or marvelous only sometimes. So I want to make an Auto_monitor...
--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)

February 16, 2009 at 10:39 am

#944716
RE: How to add cost percentage to product

AFCC Inc. Com (2/15/2009)
Yes.....
Now if it is blinds they are priced by width and height, "a grid"
I have attached an example grid that is used by the blind manufacturers 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)

February 16, 2009 at 10:26 am

#944710
RE: Building a view to get summary data from multiple tables

Heh... well said. Actually, I hated the old outer join notation... especially since Oracle and SQL Server did it exactly the opposite from each other.
--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)

February 16, 2009 at 10:20 am

#944708
RE: Are the posted questions getting worse?

Derek Dongray (2/16/2009)
bitbucket (2/13/2009)
shhh tell no one, but heck it was better than using a slide rule to do the calculations.
I still have my slide rule and can even remember...
--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)

February 16, 2009 at 10:16 am

#944704
RE: Are the posted questions getting worse?

Derek Dongray (2/16/2009)
Sounds like perfect training...
Take a rat. Drop it in a maze. If it takes the wrong path, it gets shocked. If it takes the right path, it gets...
--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)

February 16, 2009 at 10:14 am

#944701
RE: SQL or Oracle

Bruce W Cassidy (2/15/2009)
Jeff Moden (2/15/2009)
Anything that won't even allow for more than a 30 character object name certainly isn't the most flexible of the two.
[font="Verdana"]Okay, now I have to...
--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)

February 16, 2009 at 9:58 am

#944690
RE: SQL or Oracle

Bruce W Cassidy (2/15/2009)
Jeff Moden (2/15/2009)
Not even close... in no way is Oracle even close to SQL Server or vice versa. Let's start with the basics, like returning 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)

February 16, 2009 at 9:55 am

#944687
RE: Sql Query problem

sumit-saini (2/15/2009)
i had tested this code in sql 2000
SELECT id,
days,
days - COALESCE((SELECT max(days)
...
--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)

February 16, 2009 at 9:38 am

#944672
RE: Create a non clustered index on a 400million rows

400 Million rows? Consider partitioning that bad boy.
--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)

February 16, 2009 at 9:07 am

#944636
RE: SP that shows Actual space used & assigned to all files in a DB

I'm sure there's a better way than the code I modified to go from 2k to 2k5... I haven't nailed down all of the new system views that came 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)

February 15, 2009 at 8:44 pm

#944324
RE: count of consecutive value

Nice job, but recursion is actually slower than a cursor.
--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)

February 15, 2009 at 8:05 pm

#944319
RE: Why do people need to do this?

Heh... simple... the software was the very fabric of their business {visibly and audibly gagging at the terrible pun} 😛
--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)

February 15, 2009 at 8:02 pm

#944318
RE: Why do people need to do this?

... and, no.... again, I don't need to know how to solve the problem... I've done it at least a half dozen times with the "running total update" and once...
--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)

February 15, 2009 at 7:56 pm

#944316

Viewing 15 posts - 45,151 through 45,165 (of 59,101 total)