Jeff Moden

Forum Replies Created

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

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
RE: Which country is best for Outsourcing?

Heh... there's some extremely talented folks right here in the U.S.A....
Here's your function...
[font="Courier New"]--===== Create the "strip tags" function using a typical While Loop
-- (by Robert Davis)
-- http://www.databasejournal.com/scripts/article.php/3494196/Function-to-strip-HTMLASPPHP-tags-from-text.htm
Create...
--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:31 am

#982671
RE: SQL convert 1 column's values to 1 row string

Bob Hovious (4/22/2009)
🙂
Heh... nope... not stalking. :hehe:
--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 22, 2009 at 2:17 pm

#982504
RE: How To Format Phone Number

YSLGuru (4/22/2009)
Replies like this are exactly the reason why SQLServerCentral.com pays you the BIG bucks! This is a great answer and I would implement it if it weren't 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)

April 22, 2009 at 2:12 pm

#982501
RE: How To Format Phone Number

Bob Hovious (4/22/2009)
No problem. Here's what I've got. My understanding is that it can't be used for commercial purposes.
Jeff: Who did your awesomely animated NO...
--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 22, 2009 at 2:05 pm

#982493

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