Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,071 through 44,085 (of 59,101 total)

RE: Crosstab type report -- Horizontal Summray

Joseph,
Did you ever get this figured 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)

April 23, 2009 at 5:40 pm

#983329
RE: Pivot tha data in this format

Thanks for the feedback. I always wonder if some of these suggestions get through or not.
--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 23, 2009 at 5:32 pm

#983327
RE: Are the posted questions getting worse?

GSquared (4/23/2009)
"Bait and Switch".
BWAA-HAA!!! Energy drink my foot! It would be a heck of a name for a marriage counseling service. 😛
--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 23, 2009 at 5:04 pm

#983322
RE: Are the posted questions getting worse?

Adi Cohn (4/23/2009)
Since we are sharing some bad code stories, I have to tell you the true and sad story from few years ago. At that time I was...
--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 23, 2009 at 4:57 pm

#983319
RE: Are the posted questions getting worse?

Alvin Ramard (4/23/2009)
GSquared (4/23/2009)
Laughable SQL would be a great topic. Probably quite popular, and potentially quite valuable.
Could have examples of some of the really bad cursor solutions as one...
--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 23, 2009 at 4:51 pm

#983315
RE: Are the posted questions getting worse?

Greg Edwards (4/23/2009)
Bob Hovious (4/23/2009)
My topic would more likely be... Laughable SQL
Why isn't there an SQL equivalent to Iron Chef? That would make for an interesting competition. ...
--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 23, 2009 at 4:46 pm

#983313
RE: Which country is best for Outsourcing?

Chirag,
Heh... man, I can only imagine some of the legacy code you must get from some folks. That's gotta be a nightmare especially when there's no documentation anywhere especially...
--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 23, 2009 at 3:01 pm

#983283
RE: Which country is best for Outsourcing?

umar iqbal (4/23/2009)
I have on solution for all this and don't laugh. lets bring dollar value to NULL
Heh... I thought it was already there. 😀
--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 23, 2009 at 2:50 pm

#983276
RE: Which country is best for Outsourcing?

Robert Davis (4/23/2009)
Actually, I am not in favor of outsourcing. But there are good and bad coders both in and out of the USA.
Quality should be the top priority of...
--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 23, 2009 at 11:50 am

#983154
RE: Which country is best for Outsourcing?

Robert Davis (4/23/2009)
Jeff Moden (4/23/2009)
Heh... there's some extremely talented folks right here in the U.S.A....
Wow, you took a function I wrote more than 4 years ago and sped it up...
--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 23, 2009 at 11:16 am

#983126
RE: Performance issue with tally solution

Derek Dongray (4/23/2009)
Hi Bob,
I did a few more tests (beyond the earlier table) and on my systems, the double-tally acheives better than half CPU time at long executions (.e.g 146...
--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 23, 2009 at 8:56 am

#982984
RE: Which country is best for Outsourcing?

JacekO (4/23/2009)
Muhammad Kashif Azeem (4/23/2009)
O.k Jeff you are specialize in efficient stored procedure designing. We will chosen you to design good stored Procedures. But we won't give you complete project....
--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 23, 2009 at 8:43 am

#982969
RE: Which country is best for Outsourcing?

Muhammad Kashif Azeem (4/23/2009)
O.k Jeff you are specialize in efficient stored procedure designing. We will chosen you to design good stored Procedures. But we won't give you complete project. Because...
--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 23, 2009 at 8:27 am

#982953
RE: How do I display thousand separator for floats?

Both are good solutions, but I prefer Wayne's method just because it's a bit easier on the eyes.
--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 23, 2009 at 8:22 am

#982947
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

gserdijn (4/23/2009)
DECLARE @Txt VARCHAR(MAX)
SELECT @Txt = ''
SELECT @Txt = @Txt + ao.name + ao.type_desc + CHAR(13) + CHAR(10)
FROM SYS.all_objects ao WHERE ao.type IN ('U' , 'V')...
--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 23, 2009 at 12:42 am

#982672

Viewing 15 posts - 44,071 through 44,085 (of 59,101 total)