Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,041 through 44,055 (of 59,063 total)

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
RE: Convert nvarchar to numeric

Lately, it won't even let you delete your own post.
--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:01 pm

#982491
RE: CONVERT nvarchar to numeric

jsheldon (4/20/2009)
Francis,
Your code was the best fit...thanks to all for the help...
Just don't rely on ISNUMERIC being some sort of magical ISALLDIGITS function because it's not. Please see the...
--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 1:53 pm

#982484
RE: Counting problem

Mark (4/17/2009)
WITH CTE AS (
SELECT CUSTOMER_NO,
CURRENT_BALANCE,
ACTUAL_DATE,
ROW_NUMBER() OVER(PARTITION BY CUSTOMER_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 1:17 pm

#982462
RE: Need to display ALL rows, even with Zero count

The problem is probably what you're grouping by. Which tables do all the columns belong to? The easiest way to describe that is to apply correct table aliases...
--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 1:07 pm

#982452

Viewing 15 posts - 44,041 through 44,055 (of 59,063 total)