Jeff Moden

Forum Replies Created

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

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

I've been very disappointed with every outsourcing venture we've had, so far. Examples include such things as code that has UDF's that call 4 levels of UDF's and things...
--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 9:58 am

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

RBarryYoung (4/22/2009)
WayneS: yeah, what Jeff said. Sorry 🙂
Heh... no need to be sorry... it's a very common typing mistake that I occasionally make myself. The names are...
--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 9:51 am

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

Try Master.sys.SYScolumns instead... it contains at least 11,000 rows which will produce up to 121 million rows with a single cross-join. And, although it looks fine, double cross joins...
--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:03 am

#981957
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thanks, Manie. I sure do appreciate the feedback.
--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 21, 2009 at 11:57 pm

#981953

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