Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,286 through 48,300 (of 59,102 total)

RE: converting text to int

Jeff (9/17/2008)
I did try that first. It gives the error:
Server: Msg 235, Level 16, State 1, Line 1
Cannot convert a char value to money. The char value has incorrect...
--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)

September 17, 2008 at 6:53 pm

#873323
RE: Keep first row in grouped data

As so many will, undoubtedly, tell you, how do you know what the "first" record really is? There's no guarantee that the order you enter the data will stay...
--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)

September 17, 2008 at 6:35 pm

#873320
RE: Databases for Change

Great article and very well presented as JJ B and a couple of others noted.
I take no offense to building a database of lobbyists, etc... but instead of spending good...
--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)

September 17, 2008 at 6:24 pm

#873318
RE: An interview with the Exceptional DBA of the Year

Outstanding accomplishments, Dan. Well deserved award!
--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)

September 17, 2008 at 6:17 pm

#873316
RE: Patindex

Wayne West (9/17/2008)
Jeff Moden (9/16/2008)
... The real key is that I have a good friend that I argue with/agree with once in a while. He said something I'll never...
--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)

September 17, 2008 at 6:07 pm

#873315
RE: functions

Yeah... I know, Sergiy. Really just wanted you to post it on this thread so others can learn. Thanks. 🙂
--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)

September 17, 2008 at 5:58 pm

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

Thanks, Madhivanan, my old friend. No, haven't written Part II to this article, yet. Got caught up in a new job and can hardly keep up with new...
--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)

September 17, 2008 at 5:56 pm

#873313
RE: Splitting a String in SQL - Help Please!

Sergiy (9/16/2008)
But I know how it should be...
If any time you come up with an idea how to split quoted string usint Tally table - you know who's gonna appreciate...
--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)

September 16, 2008 at 11:02 pm

#872794
RE: Splitting a String in SQL - Help Please!

Chirag (9/16/2008)
What happened to op?
I think we lost him a long time ago. He never did answer if it was for a single parameter or for a whole column....
--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)

September 16, 2008 at 10:06 pm

#872790
RE: Splitting a String in SQL - Help Please!

Heh... I might have it, ol' friend... I can't explain it, I just gotta do it. I'll be back. And you're right about the table... 3 columns. 🙂
--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)

September 16, 2008 at 7:47 pm

#872773
RE: Splitting a String in SQL - Help Please!

By the way, when I said "It sure does", I meant it sure does fail... and in exactly the manner you suggested. Sorry for the confusion. 🙂
I'll be back......
--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)

September 16, 2008 at 7:27 pm

#872770
RE: Create string from table

Ya beat me to it, John. 🙂
Not 100% sure but, using your good data, I think example 1 was meant to be something on the order of...
-- Example 1
DECLARE @EMail...
--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)

September 16, 2008 at 7:09 pm

#872769
RE: Adding +1 to MAX()

Dugi (9/16/2008)
This is the reason why you are or you should be the SQL SERVER MVP ...yayaya :hehe::hehe::hehe:
Jeff, this code works perfect!
Heh... thanks for the awesome feedback, Dugi.
Still,...
--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)

September 16, 2008 at 6:16 pm

#872763
RE: Patindex

Manie, I gotta say it again... good article. You brought some good people out in the discussion about PatIndex. Nicely done! 🙂
--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)

September 16, 2008 at 6:04 pm

#872762
RE: Patindex

dphillips (9/16/2008)
Jeff, great examples and test building. It amazes me you have the time to post such significant and applicable content and in such detail.
Thank you for your many...
--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)

September 16, 2008 at 6:03 pm

#872761

Viewing 15 posts - 48,286 through 48,300 (of 59,102 total)