Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,751 through 42,765 (of 59,102 total)

RE: Are the posted questions getting worse?

Paul White (7/26/2009)
Still, $799 looks better as US$524 - is that expensive? I honestly don't know.
It's more than a week's pay for a lot of folks. I know...
--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)

July 26, 2009 at 1:30 am

#1030253
RE: You guys suck. every time we have to go and register or it says we have to go and click the f**king link. and the email doesnt get send immediately.

RBarryYoung (7/10/2009)
arthykannan (7/6/2009)
You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email doesnt...
--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)

July 26, 2009 at 1:19 am

#1030251
RE: Heh... I broke it.

I almost forgot... yes, I'm using IE.
--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)

July 26, 2009 at 1:15 am

#1030249
RE: differiniate quotes as data vs quotes as column identifier
Ok... here's a full up working example with the data you provided. As always, the detail is in the comments in the code...
```
--===========================================================================================================
--      We...
```
--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)
July 26, 2009 at 12:37 am

#1030248
RE: differiniate quotes as data vs quotes as column identifier

Ummmm.... "Weekend".... new word for me... guess I'll have to look it up. 😛
Since you know how to do the BULK INSERT, we'll start with a staging table... I'll be...
--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)

July 25, 2009 at 11:21 pm

#1030245
RE: differiniate quotes as data vs quotes as column identifier

Ah... sorry, Ghanta... I've got just one more question...
Do you know how to BULK INSERT a file into a single column table or not?
--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)

July 25, 2009 at 11:17 pm

#1030243
RE: differiniate quotes as data vs quotes as column identifier

Ghanta (7/25/2009)
Jeff Moden (7/25/2009)
Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...
1st field - never quoted
2nd field -...
--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)

July 25, 2009 at 11:11 pm

#1030242
RE: differiniate quotes as data vs quotes as column identifier

Jeff Moden (7/25/2009)
Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...
1st field - never quoted
2nd field - always...
--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)

July 25, 2009 at 11:07 pm

#1030241
RE: differiniate quotes as data vs quotes as column identifier

BobMcC (2/18/2008)
I need to import (using DTS) some comma delimited text files into sql server 2000.
I have discovered that the quotation mark is getting dual use. Not only is some...
--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)

July 25, 2009 at 11:00 pm

#1030239
RE: differiniate quotes as data vs quotes as column identifier

Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...
1st field - never quoted
2nd field - always quoted
3rd field...
--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)

July 25, 2009 at 10:49 pm

#1030237
RE: differiniate quotes as data vs quotes as column identifier

Ok.... a couple of questions...
First, some data from your post...
[font="Courier New"]6053339541,"11 LONG CIRCULAR ROAD ,ST,JAMES,",05,this is a sample,"tiger, scott"
__________ ________________________________ __ ________________ ____________
6053339542,"11 LONG CIRCULAR ROAD ,ST,JAMES,",05,this is a sample,"tiger, scott"
__________ _____________________________________ __ ________________ ____________
6053448211,"L'ARGENTIERE BAT A, 637 BD TAVERNIERE",02,this is a sample,"tiger, scott"[/font]
1. Except for the first column (ID), the first 2 rows above appear to be duplicates. Should one...
--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)

July 25, 2009 at 10:46 pm

#1030236
RE: Are the posted questions getting worse?

Paul White (7/25/2009)
Talking of number plates, a guy who used to work at my place had SQLDBA as his plate.
I quite fancy this one or this one
Anyone got any clever...
--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)

July 25, 2009 at 10:33 pm

#1030235
RE: Are the posted questions getting worse?

Jack Corbett (7/25/2009)
For Jeff, PRKCHP
or
BACKUP
or
RSTORE
Heh... I prefer ...
NO RBAR
or
RTFM
or
MILTP41
or
DIEANSI
or my favorite...
TALLYTBL
--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)

July 25, 2009 at 10:20 pm

#1030234
RE: Index scan hint

Paul White (7/25/2009)
I realize my point was slightly off-topic, but I couldn't resist the opportunity to discuss some of the subtleties.
Speaking of "off topic"... that's part of the reason...
--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)

July 25, 2009 at 9:45 pm

#1030231
RE: Existance Check - Performance

matt stockham (7/24/2009)
Jeff Moden (7/24/2009)
happycat59 (7/23/2009)
Using COUNT(1) requires SQL Server to return all records that meet the criteria.
Ummmm.... nope... it doesn't... it stops searching as soon as it finds one...
--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)

July 25, 2009 at 9:40 pm

#1030229

Viewing 15 posts - 42,751 through 42,765 (of 59,102 total)