Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,666 through 7,680 (of 59,072 total)

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, 4 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
Reply To: Importing Tricky CSV Files with PowerShell

Post removed.
--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 2:19 am

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

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 experience it's...
--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 1:46 am

#3729481
Reply To: Remove attachment from a post

Steve Jones - SSC Editor wrote:
I don't think things overwrite, but if you give a URL to the post, we can remove the attachment.
I recently did the same thing and can confirm that things...
--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 27, 2020 at 8:30 pm

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

Lynn Pettis wrote:
Is this coming to you in a file?
You beat me to that question, Lynn. If it is (and I think this is where your going with this), we can...
--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 27, 2020 at 8:26 pm

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

Thom A wrote:
How to you get 26 different columns from the string 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P'? I see 6 at most. Where are the other 20 coming from?
Fixed field...
--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 27, 2020 at 8:19 pm

#3729412
Reply To: SQL Server data masking

Admingod wrote:
I was looking at native option. So you saying using sql server native method data masking can be done from SQL server 2016 onwards?
If you look at my definition...
--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 27, 2020 at 12:34 am

#3729135
Reply To: SQL Server data masking

Absolutely agreed. To me, the term "mask" or "data masking" actually has nothing to do with changing the underlying data. It's a poorly chosen term (IMHO) except when it's used...
--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 26, 2020 at 11:46 pm

#3729129
Reply To: Question upgrading

I always just ask management if they'd eat a 2 year old egg. 😀
--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 26, 2020 at 8:05 pm

#3729056
Reply To: SQL Server data masking

Maybe the native Dynamic Data Masking feature first made available in 2016 would be a good enough reason to update 2012 to 2019 sooner than later?
--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 26, 2020 at 8:03 pm

#3729055
Reply To: Back from My Sabbatical

Welcome back, Steve! Everything was very good and very well covered but it just wasn't the same without 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)

February 26, 2020 at 4:27 am

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

jasona.work wrote:
OK, bit of a vent here, feel free to ignore me...
WHY can you not use DTUTIL to import a password-protected SSIS package? Honestly, why? Today I had to migrate...
--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 26, 2020 at 4:25 am

#3728786

Viewing 15 posts - 7,666 through 7,680 (of 59,072 total)