Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,511 through 12,525 (of 59,102 total)

RE: Unable to get format file to work

p.s. Almost without exception, I load files to a staging table first so that I can validate data, check for duplicates, etc, yada, yada. With that in mind, I also...
--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 22, 2018 at 9:47 pm

#1987837
RE: Unable to get format file to work

No problem. Thank you for the feed back. Excluding fields in the file is pretty easy... assign them a column number of 0 (zero) and give them a unique...
--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 22, 2018 at 9:43 pm

#1987836
RE: Select All Records Where Date Falls Within Next Week

Between knowing that day "0" is the first of January, 1900 and that day was a Monday along with a little integer math and a little direct date math, 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 22, 2018 at 9:34 pm

#1987835
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 9:13 PM
Jeff Moden - Sunday, April 22, 2018 9:08 PM
--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 22, 2018 at 9:15 pm

#1987833
RE: Unable to get format file to work

Jeff Moden - Sunday, April 22, 2018 9:08 PM
ron.abbott - Sunday, April 22, 2018 8:25 PM
--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 22, 2018 at 9:13 pm

#1987831
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 8:25 PM
The txt file was generated by a software package that I am unfamiliar with.
Not sure...
--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 22, 2018 at 9:08 pm

#1987829
RE: Unable to get format file to work

I was able to duplicate the error even after adding the / n. 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)

April 22, 2018 at 8:23 pm

#1987826
RE: Unable to get format file to work

That should do... let me see what gives.
--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 22, 2018 at 8:17 pm

#1987825
RE: Unable to get format file to work

Ah. Ok. Speaking of tables, can you post the CREATE TABLE statement for the table this file is supposed to go into? That way, I can do some testing.
--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 22, 2018 at 8:10 pm

#1987823
RE: Unable to get format file to work

Also, since this is a really clean and consistent text file, why are you bothering with a BCP format file to begin with?
--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 22, 2018 at 8:07 pm

#1987821
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 7:53 PM
It was generated using the format option of the bcp command
BCP Rest01.dbo.RestCreditors Format null -T...
--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 22, 2018 at 7:58 pm

#1987819
RE: Unable to get format file to work

ron.abbott - Sunday, April 22, 2018 7:19 PM
I am importing a text file with tab delimiters into an SQL2005 table.
The BCP command...
--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 22, 2018 at 7:48 pm

#1987815
RE: INSERT INTO from one table to another table show duplicate row ??? WHY

mrceski - Sunday, April 22, 2018 3:09 PM
You mean check existing records before INSERTI NTO (transfer from TableIzlezDneven to Tablelzlez) or after...
--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 22, 2018 at 4:04 pm

#1987809
RE: user typed "begin transaction" and went home

coolchaitu - Saturday, April 21, 2018 11:10 AM
Good Morning Experts,
A user typed "begin transaction" and went home. Will this have any...
--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 22, 2018 at 2:22 pm

#1987803
RE: INSERT INTO from one table to another table show duplicate row ??? WHY

mrceski - Sunday, April 22, 2018 1:50 PM
No TableIzlez is not empty.
That table is fill from TableIzlezDneven every day (one time) 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)

April 22, 2018 at 2:09 pm

#1987802

Viewing 15 posts - 12,511 through 12,525 (of 59,102 total)