Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,006 through 34,020 (of 59,099 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (5/9/2011)
Jeff Moden (5/8/2011)
By the way... I've attached the final results which also contains more charts than you can shake a stick at.
And wow, that Split method (green line) does...
--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)

May 9, 2011 at 4:33 am

#1321622
RE: Looking for Work in SQL Server

Nicely written and sage advice all around. Well done, Craig.
--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)

May 9, 2011 at 4:21 am

#1321621
RE: What happened to Proclarity

stevefromOZ (5/8/2011)
@jeff - I'm a huge fan but the question had definitely been answered 3+ years ago :hehe:
Maybe so... for then. The additional information doesn't hurt.
--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)

May 8, 2011 at 10:54 pm

#1321532
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

By the way... I've attached the final results which also contains more charts than you can shake a stick at.
--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)

May 8, 2011 at 10:35 pm

#1321526
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Ok... Peter and Nadrek... I need to know your real names for inclusion in the final documentation in the updated sprocs that I'm going to attach to the article. ...
--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)

May 8, 2011 at 10:19 pm

#1321524
RE: Hexadecimal value to Decimal value

mj.richardson (5/8/2011)
You've actually not given us much to go on. How do you figure that "Sawyer Mickeymouse" converts to 331010 and that "Jill 64191" converts to 41000110?
I'll tell you right...
--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)

May 8, 2011 at 8:47 pm

#1321518
RE: Select with "IN" clause

Just in case you're REALLY new... the "Books Online" Wayne speaks of is the Help system that comes with SQL Server.
--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)

May 8, 2011 at 7:07 pm

#1321514
RE: What happened to Proclarity

Besides... it's nice to see someone finally answer the question... even after 4 years and with a bit of "advertising". 🙂
--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)

May 8, 2011 at 7:04 pm

#1321513
RE: Is SQL trng apropriate for our needs

My recommendation is to NOT let the users anywhere near the production server with their own queries even after training. I recommend, instead, that you make a copy 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)

May 8, 2011 at 6:59 pm

#1321512
RE: Get the First letter of each word within a string and returned a concatenated string

peterzeke (5/6/2011)
It appears I've found one solution which I should be able to put into a udf:
DECLARE @STRING VARCHAR(8000)
SET @STRING = 'COMMUNITY GENERAL HOSPITAL'
DECLARE @TEXTXML XML
SELECT @textXML = cast('<d>'...
--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)

May 8, 2011 at 6:31 pm

#1321510
RE: Get the First letter of each word within a string and returned a concatenated string

Vedran Kesegic (5/8/2011)
This handles different separator characters (not just space),
handles multiplication of the separators (e.g. double space or space at the beggining of the string),
and works from SQL 2000 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)

May 8, 2011 at 6:29 pm

#1321508
RE: Hexadecimal value to Decimal value

You've actually not given us much to go on. How do you figure that "Sawyer Mickeymouse" converts to 3310₁₀ and that "Jill 64191" converts to 410001₁₀?
I'll tell you right...
--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)

May 8, 2011 at 6:17 pm

#1321507
RE: SQL Spackle - Find 0 values in sums by date

Patrick Cahill (3/10/2011)
Jeff Moden (3/10/2011)
I'll be happy to provide a technical review on this one, Patrick. Drop me an email, if you'd like.
Thanks Jeff, I'll send you an 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)

May 8, 2011 at 5:19 pm

#1321504
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Tom.Thomson (5/7/2011)
ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
I'll second that suggestion....
--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)

May 7, 2011 at 9:02 pm

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

Ok, Shannon... here's part 1. No need for a Tally Table just to figure out if a "cell" has "weird" characters in it. The following code makes 100,000...
--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)

May 7, 2011 at 8:52 pm

#1321438

Viewing 15 posts - 34,006 through 34,020 (of 59,099 total)