Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,681 through 7,695 (of 59,098 total)

Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Phil Parkin wrote:
This is a tidy approach, but I'd have concerns, from an audit point of view, about data having been manipulated before it even hits the database. Potentially makes that...
--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)

March 2, 2020 at 4:31 pm

#3730224
Reply To: What Happened to Hadoop?

Eric M Russell wrote:
HDFS is alive and well - just like SQL was never threatened. I'm reminded of those Reeses Cups commercials from the 80's where two people collide - one 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)

March 2, 2020 at 4:20 pm

#3730208
Reply To: Casting Tiny Numbers

Good basic question, Steve. My only objection would be the title of the question itself because this also occurs for much larger numbers and larger VARCHARs.

--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)

March 2, 2020 at 3:00 pm

#3730172
Reply To: Indexed view using remote database

Most people want to make indexed views for performance purposes which, of course, don't work on remote servers because of the schema binding issue.
If you don't really need it 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)

March 1, 2020 at 8:29 pm

#3729984
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

@andrew Goffin-302397 ,
I realize the your post has been hijacked, so I'm still trying to get it back on track but I need that bit of info I've been asking...
--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)

February 29, 2020 at 9:55 pm

#3729884
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

BHWAAA-HAAAAAAA!!!! And... it doesn't use curly braces. 😀
--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)

February 29, 2020 at 9:52 pm

#3729883
Reply To: Data Orchestration

skeleton567 wrote:
I just rejected a new version of software I've used for decades because it now requires that I connect to internet each time I use it. Ain't gonna happen.
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)

February 29, 2020 at 1:36 am

#3729788
Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
Lynn Pettis wrote:
MVDBA (Mike Vessey) wrote:
Lynn Pettis wrote:
MVDBA (Mike Vessey) wrote:
I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) 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)

February 28, 2020 at 11:15 pm

#3729767
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Jeffrey Williams wrote:
I think we went backwards...
I especially agree with that sentiment.
--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)

February 28, 2020 at 7:47 pm

#3729706
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Personally, I'm REALLY happy that the whole world hasn't adopted EDI. IMHO, it's another hierarchical nightmare of data that's even worse than things like "packed decimal".
This is what I'm talking...
--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)

February 28, 2020 at 7:06 pm

#3729691
Reply To: Returning Info from Stored Procedures

I got it right only because I mentally limited the question to "typical documented" methods. It's also why I hate tests. It's like asking the question of "Which is 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)

February 28, 2020 at 4:40 pm

#3729643
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Andrew Goffin-302397 wrote:
Hi,
I have a 80 character piece of text that I wish to convert to a table structure that represents that data.
Is there a simple way to take those 80...
--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)

February 28, 2020 at 4:09 pm

#3729623
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Jonathan AC Roberts wrote:
MVDBA (Mike Vessey) wrote:
Jonathan AC Roberts wrote:
MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for...
--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)

February 28, 2020 at 4:01 pm

#3729619
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.
Jonathan AC Roberts wrote:
MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In...
- This reply was modified 6 years, 7 months ago by Jeff Moden.
--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)
February 28, 2020 at 3:53 pm

#3729610
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.
In my...
--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)

February 28, 2020 at 3:47 pm

#3729608

Viewing 15 posts - 7,681 through 7,695 (of 59,098 total)