Jeff Moden

Forum Replies Created

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

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
RE: INSERT INTO from one table to another table show duplicate row ??? WHY

mrceski - Sunday, April 22, 2018 6:01 AM
I use this code:
INSERT INTO
TableIzlez ([BrojNaSmetka],[Artikal],[Sifra],[Kolicina],[Cena_P],[Cena_N],[Prodavac],
[Datum],[Fiskalna],[MasaBroj],[Oddel],[Zatvorena],[PodGrupa],[Cena_Produkti],[TipNaSmetka],[DDV],[Den])
SELECT
BrojNaSmetka,Artikal,Sifra,Kolicina,Cena_P,Cena_N,Prodavac,Datum,
Fiskalna,MasaBroj,Oddel,Zatvorena,PodGrupa,Cena_Produkti,TipNaSmetka,DDV,'19.04.2018'
FROM TableIzlezDneven
Aftrer this code I delete the table...
--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 1:43 pm

#1987800
RE: YTD Calculation

jallowmarie - Saturday, April 21, 2018 3:38 PM
hi ,
i need help with calculating YTD for Tax and TaxablePay. I already have a...
--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 12:41 pm

#1987798
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, April 20, 2018 12:18 PM
Lynn Pettis - Friday, April 20,...
--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 20, 2018 at 1:05 pm

#1987746
RE: Keep It All

Eric M Russell - Friday, April 20, 2018 12:15 PM
jay-h - Friday, April 20, 2018 11:30 AM
--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 20, 2018 at 1:03 pm

#1987744
RE: Where GROUPING SETS is used.

Key point here... don't confuse OLAP Cubes with the WITH CUBE option of GROUP BY.
--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 20, 2018 at 11:54 am

#1987727
RE: Are the posted questions getting worse?

Lynn Pettis - Friday, April 20, 2018 10:15 AM
Jeff Moden - Friday, April 20, 2018 9:07 AM
--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 20, 2018 at 10:29 am

#1987706
RE: Keep It All

Shifting gears a bit, we're setting up to delete 1TB from a 1.4TB database and 600GB from a 1TB database. The data we're dropping is simply data that no 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)

April 20, 2018 at 9:34 am

#1987690

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