Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,746 through 47,760 (of 59,102 total)

RE: Problem with this script, need help!

Guess I don't see it since you have the same thing in the SELECT list... should fail there, too. Maybe, I've just not had enough coffee today. Sorry,...
--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)

October 14, 2008 at 9:26 pm

#884999
RE: Problem with this script, need help!

Heh.. yeah... you're right. Still looking.
--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)

October 14, 2008 at 9:14 pm

#884997
RE: Too Good at Data Analysis

They knew the models weren't perfect...
... but the morons did it anyway. That bloody well sums it up and that's why "Business Intelligence" is an oxymoron. 😉 There's...
--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)

October 14, 2008 at 8:51 pm

#884987
RE: Problem with this script, need help!

If FName has no spaces, the CHARINDEX will return 0 and then you subtract 1 to make the operand of LEFT a negative number. You need to check 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)

October 14, 2008 at 8:44 pm

#884985
RE: Removing partially duplicate records in SQL

Max,
Can there be a 4th possibility or not?
RECID COL1 COL2 ...
--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)

October 14, 2008 at 8:32 pm

#884984
RE: To get rows in CSV format

Shree (10/14/2008)
Hi, I saw that article and tried but its not working. Its giving me null values.
What did you try? Please post the code and the data you tried...
--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)

October 14, 2008 at 7:23 pm

#884981
RE: Functio to get Amount in words.

TheSQLGuru (10/14/2008)
That site has a lot of really great stuff. Aaron Bertrand, IIRC.
And I too think this is a presentation layer item. Or perhaps a CLR function??
I agree......
--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)

October 14, 2008 at 7:21 pm

#884980
RE: Convert rows into columns

Shree (10/14/2008)
Sorry, actually I posted in the wrong forum before. I didn’t find the option to delete the topic. Anyway Madhivanan helped me by giving me this article link.
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx
That's a...
--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)

October 14, 2008 at 7:16 pm

#884979
RE: Nested while is not working

noeld (10/14/2008)
By this time I think the PO is not longer with us (no pun intended)
Heh, agreed. It's a shame, too. I would have liked to take a...
--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)

October 14, 2008 at 7:06 pm

#884977
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Dang... I gotta learn to read all the new posts before I reply...
Richard Fryar's fine solution is a dynamic solution that will work fine in SQL Server 2005.
Heh... if you...
--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)

October 14, 2008 at 7:00 pm

#884976
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

jon.malenfant (10/14/2008)
Taking this to the next level, let's look at textual data instead of numeric. Consider two tables with a one to many relationship. We can even remove...
--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)

October 14, 2008 at 6:57 pm

#884975
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Charles Kincaid (10/14/2008)
It's practically impossible to meaningful queries as you have seen.
But, "practically" and "is" are two different 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)

October 14, 2008 at 6:55 pm

#884974
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

peter (9/30/2008)
As I should, I will do some thorough testing with a recognizable real world problem. It will take me a few days before I can do so and am...
--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)

October 14, 2008 at 6:41 pm

#884972
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

GF (10/14/2008)
Jeff, this is a great article.
I do have a question as I am trying to apply your solution to my needs.
I have hundreds of addresses in a single address...
--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)

October 14, 2008 at 6:38 pm

#884971
RE: Nested while is not working

Still, the code is doomed to be comparatively slow because of the loops. If we knew the actual problem this was supposed to solve, perhaps we could find a...
--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)

October 14, 2008 at 5:26 am

#884540

Viewing 15 posts - 47,746 through 47,760 (of 59,102 total)