Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,086 through 44,100 (of 59,101 total)

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
RE: How do I display thousand separator for floats?

Dizzy (4/21/2009)
I am working with an application that lets me create filter lists of data for display in a dashboard using SQL statements.
The filter and dashboard components 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 22, 2009 at 12:37 pm

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

Now, wait a minute... concatenation is usually a mistake. What is this for (ie, business reasons other than "it's a requirement") and why do you need to do 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)

April 22, 2009 at 12:13 pm

#982399
RE: How To Format Phone Number

YSLGuru (4/16/2009)
How To Display Phone Number Formatted
How To Apply Mask To Phone Number
Q: How best to display a phone number that is stored raw (without any formatting or delimeters) 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)

April 22, 2009 at 12:10 pm

#982397
RE: How To Format Phone Number

Bob Hovious (4/17/2009)
Good point, Jack. Although we do formatting at the db level for consistency, if you just stored phone numbers as integers, you would trim fat...
--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 12:07 pm

#982393
RE: Pivot tha data in this format

vkoka (4/22/2009)
thanks for giving reply. in result i want
-----------------------------------------
actuals/budget | Revenue | Month | year |
------------------------------------------
Actuals |100 ...
--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 11:56 am

#982385
RE: Help Solving Running Total Problem

Heh.... never mind... I didn't read down far enough.
--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 11:51 am

#982384
RE: Help Solving Running Total Problem

Goldie Graber (4/20/2009)
As a post script, I ended up using Bevan's method.
It works well on tables with up to a few million records. Takes a minute or two.
When I had...
--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 11:46 am

#982380

Viewing 15 posts - 44,086 through 44,100 (of 59,101 total)