SQLPHX @SQLPHX1

Each day brings you life lessons, some are just harder to process Joined May 2019

Tweets

28
Followers

13
Following

31
Likes

27

SQLPHX @SQLPHX1

5 years ago

@SQLEspresso Thank you!

0 0 0 0 0

View Details

SQLPHX @SQLPHX1

5 years ago

@SQLEspresso Monica, if I sign up for the session and I am not able to attend, would it be recorded so it can be viewed later?

1 0 0 0 0

View Details

The Lincoln Project @ProjectLincoln

5 years ago

Here’s the letter George H. W. Bush left Bill Clinton on the first day of his presidency. A lesson in grace.

728 4K 30K 0 207

View Details

Then I need to grab the appropriate columns from Excel and add them to the “H”eader or “L”ine line in order to import the CSV. I don’t use excel much, any recommendations on the quickest way to do this? Thanks! #sqlhelp 2/2

1 0 0 0 0

View Details

SQLPHX @SQLPHX1

6 years ago

I have an excel spreadsheet that needs to be converted to CSV following using a certain format, then imported into the db. The primary key will be created during the import but I have to split each Excel line into 2 lines on the CSV file: “H” & “L” (header and lines) #sqlhelp 1/2

0 0 0 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

@DesertIsleSQL Makes sense. I have been telling everyone that it was such a great experience and that's how a conference should be run. Had fun seeing you on the panel during the Speaker Idol finals!

1 0 1 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

@SQLEspresso You did a great job! Thank you!

0 0 1 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

@SQLEspresso I am there! Looking forward to the precon!

0 0 1 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

@SQLEspresso Thank you! Registered and looking forward to it.

0 0 1 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

@pshore73 @ALevyInROC @psdbatools Thank you for all your help!

0 0 0 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

Starting out as "accidental dba" & wanted to see what you use to automate manipulation of CSV files. I get a CSV file from a vendor with a lot of garbage in it. Is there a way to automate it so I can pull only certain fields from it and then import it into my DB? Thx! #sqlhelp

2 0 1 0 0

View Details

SQLPHX @SQLPHX1

7 years ago

@pshore73 @ALevyInROC Thank you, guys. I have no experience with PowerShell. Would you recommend any sources to help me get started to tackle this issue? I assume there are already scripts out there that can be modified? Thanks again!