Jeff Moden

Forum Replies Created

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

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

frederico_fonseca - Tuesday, October 16, 2018 5:29 PM
Just a quick note to say this is not forgotten - just complex and 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)

October 16, 2018 at 6:59 pm

#2009979
RE: How to flip tables in sql server 2014

andycadley - Tuesday, October 16, 2018 5:17 PM
Jeff Moden - Tuesday, October 16, 2018 2:36 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 6:36 pm

#2009978
RE: How to flip tables in sql server 2014

andycadley - Wednesday, October 10, 2018 8:53 AM
vikasjagadale8 - Sunday, October 7, 2018 12:34 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 2:36 pm

#2009963
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

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