Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,921 through 10,935 (of 59,099 total)

RE: Casting one datetime as date converts other datetime fields

robert.wiglesworth - Tuesday, October 16, 2018 9:55 AM
It is TOAD for SQL Server. I just tried the same code in Management Studio...
--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)

October 16, 2018 at 1:59 pm

#2009954
RE: Audit Trial help

SQL learner22 - Tuesday, October 16, 2018 1:30 PM
we should be able to capture any changes to any column in 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)

October 16, 2018 at 1:51 pm

#2009951
RE: Deleted

Heh... being at retirement age and looking back, I can tell you that two of the most important things for a job are 1) doing it with people that you...
--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)

October 16, 2018 at 9:43 am

#2009903
RE: What are some really dumb things you could write in a SQL Query

andrew gothard - Tuesday, October 16, 2018 5:09 AM
Jeff Moden - Wednesday, October 10, 2018 6:29...
--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)

October 16, 2018 at 9:38 am

#2009902
RE: Audit Trial help

SQL learner22 - Tuesday, October 16, 2018 8:29 AM
I admit I did not follow the standard way of posting Topics to...
--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)

October 16, 2018 at 9:33 am

#2009899
RE: Are the posted questions getting worse?

drew.allen - Tuesday, October 16, 2018 8:34 AM
Thom A - Tuesday, October 16, 2018 3:25 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)

October 16, 2018 at 9:02 am

#2009887
RE: EBCDIC file is getting loaded with all special characters in my table

Ah... another avenue is to google for "ebcdic to ascii converter". Some are converters you have to pay for but the following link provides some hope for a free method. ...
--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)

October 16, 2018 at 8:59 am

#2009885
RE: EBCDIC file is getting loaded with all special characters in my table

kashyap4007 - Tuesday, October 16, 2018 8:15 AM
Spoke with them and was told that this is the only format they hold 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)

October 16, 2018 at 8:47 am

#2009884
RE: Are the posted questions getting worse?

DesNorton - Tuesday, October 16, 2018 3:48 AM
Thom A - Tuesday, October 16, 2018 3:25 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)

October 16, 2018 at 7:45 am

#2009864
RE: Are the posted questions getting worse?

andycadley - Tuesday, October 16, 2018 4:21 AM
Michael L John - Monday, October 15, 2018 7:03 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)

October 16, 2018 at 7:44 am

#2009862
RE: Are the posted questions getting worse?

Brandie Tarvin - Tuesday, October 16, 2018 4:38 AM
Sigh.
Why oh why oh why do users not understand their own requirements? I've had...
--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)

October 16, 2018 at 7:41 am

#2009861
RE: Are the posted questions getting worse?

Brandie Tarvin - Tuesday, October 16, 2018 6:02 AM
Hee. If you had told me 2 years ago that I would be interested...
--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)

October 16, 2018 at 7:34 am

#2009859
RE: Are the posted questions getting worse?

@Thom A
I dunno, Thom... I won't help the fellow you just helped (the one with the Blue shirt) because...
--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)

October 16, 2018 at 1:37 am

#2009815
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

Nah.... do what I do... don't even bother SSIS for this.
I created files for your two sample tables being sure that the first one's lines was terminated with LF only and 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)

October 16, 2018 at 1:11 am

#2009813
RE: Read Length of first Row and Header Row Delimiter through SSIS Script Task

Sorry... I don't have a "test dtsx package", Rocky. I would have done all of this using BULK INSERT all from a stored procedure including reading the file names. I...
--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)

October 15, 2018 at 9:42 pm

#2009803

Viewing 15 posts - 10,921 through 10,935 (of 59,099 total)