Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,911 through 23,925 (of 59,102 total)

RE: Import Excel Data into SQL Table - Fails because of CR/LF

Thomas Ashby (4/9/2014)
I need to import several Excel Worksheets into SQL tables for processing, after which I will need to export to CSV files to load back into the Excel...
--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 9, 2014 at 5:13 pm

#1704717
RE: Restrict Implicit Conversion.

All good suggestions. My favorite, though, is to put the hammer on the 3rd party providing the data and get them to clean up their act.
--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 9, 2014 at 4:59 pm

#1704715
RE: Find and Replace Injection String in Server 2005

allaspects (4/9/2014)
Lynn is obviously trolling. Sad that on a resource such as this website, someone is out to troll and not help.
That's why the world can't have nice things.
From where...
--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 9, 2014 at 3:47 pm

#1704709
RE: Help need in Avoiding Loop

Gosh. Thanks, Lynn. :blush:
--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 9, 2014 at 10:30 am

#1704600
RE: generate random value before @ in email address

dallas13 (4/9/2014)
Thanks Thats much easier.
The example I created has email addresses length=8 but in reality it may be any length and I wanted to just replace as 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)

April 9, 2014 at 6:56 am

#1704482
RE: Help need in Avoiding Loop

born2achieve (4/9/2014)
Hi Jeff,
I totally agree your logic and will follow that. yes of course, knowledge can only be developed when we try.
you are great mentor. thank you.
Thank for 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 9, 2014 at 6:36 am

#1704475
RE: Team Reputation

Jim P. (4/7/2014)
Jeff Moden (4/7/2014)
I have to disagree a bit with the aspect of not saying anything if someone doesn't meet expectations. There's no doubt that not everyone on...
--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 9, 2014 at 12:57 am

#1704385
RE: Find and Replace Injection String in Server 2005

Heh... I tend to blame both. Cruddy tools being used by people that just don't know. It's a deadly combination.
--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 9, 2014 at 12:45 am

#1704383
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

Ray Herring (4/8/2014)
The direction of the discussion has strayed a little bit from the original topic:-P
The behavior you guys are discussing is not specific to Views. it is general...
--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 8, 2014 at 10:21 pm

#1704361
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

jay 87680 (4/8/2014)
Actually we went back to the original topic which was my disagreement with the following statement:
"In this case SQL Server will still have to join all the tables...
--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 8, 2014 at 10:13 pm

#1704360
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Thanks for the feedback, Kathy. If you get a chance, stop back and let us know how it worked out. I think originally deciding how to create 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 8, 2014 at 10:11 pm

#1704359
RE: Help need in Avoiding Loop

born2achieve (4/8/2014)
Hi Jeff,
I apologize for extending the thread and your time. I did try to browse through articles before i post in this forum. even i tried some sample...
--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 8, 2014 at 10:04 pm

#1704357
RE: Help need in Avoiding Loop

born2achieve (4/8/2014)
Hi Jeff,
One final question about exception. In my sample logic i am suing try catch to get the exception and transaction to rollback if any exception found. ...
--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 8, 2014 at 5:54 pm

#1704345
RE: Help need in Avoiding Loop

Just a couple of tips here...
First, although it's fast, you made the generation of the test data a wee bit complicated and a bit more difficult to read than 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 8, 2014 at 9:13 am

#1704170
RE: Get list of all workers having same SET of Rates

a.myasnikov (4/8/2014)
Just wondering what the grand-masters will say about a checksum solution?
From what I know about checksums they are pretty reliable way to tell one set from the other... ...
--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 8, 2014 at 7:33 am

#1704131

Viewing 15 posts - 23,911 through 23,925 (of 59,102 total)